Visvang
07-01-2010, 09:47 AM
Is it posible to put in 'AI' in a project.
i have i workbook with 32 sheets, and save everytime somthing in colom D changes, its fine for me, but some of my coleges find it frustrating.
Now is i posible to add a button, NOT IN THE WORKSHEETS, that the users can tic/untic to delete the worksheet.save line or add a ' caracter.
any help would help
Thank you.
Josh Hazel
07-05-2010, 03:20 PM
Here is what I would do:
if environ("username") = "your windows login name here" then
thisworkbook.save
endif
This will check the user logged in, if its you, it will save. If its not you it will do nothing!
Visvang
07-07-2010, 07:20 AM
i did manage to get my buttons to the quick acess tool bar, but im stuck again, i have the following code:
Private Sub Worksheet_Change(ByVal Target As Range)
Set isect = Application.Intersect(Target, Range("d2:d35"))
If isect Is Nothing Then
End
Else
ModDayHour.Day_Hour
ActiveWorkbook.Save
End If
End Sub
i want to remove the save line with a macro that is trigerd by a 'command button'.
i did search google and could only find examples of how to edit a modules with another, is there a way to change an event??
Visvang
07-14-2010, 09:29 AM
first i added buttons to my quick access toolbar
Customize Quick Access Toolbar → select macros from the Choose Commands From drop down list → add my macros name → Modify... → OK → and then the following code
http://www.xtremevbtalk.com/showthread.php?t=316966