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
07-05-2010, 03:20 PM
Here is what I would do:
if environ("username") = "your windows login name here" then
This will check the user logged in, if its you, it will save. If its not you it will do nothing!
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
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??
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