howardching
asked on
disable the save and saveas button and Suppress Macro warning
1) How to write code to disable the save and saveas button?
2) How to force the file opener to execute the Excel VBA (Suppress the Macro Warning)?
2) How to force the file opener to execute the Excel VBA (Suppress the Macro Warning)?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
why only mvidas??
but u need to know the control ID of the button which u want to be Disabled
and u need to go to the console for that
click start->Run->Type "MMC" and press enter
here u go
this is the console and from here itself u can disable those buttons (but how....i dunn know....sorry 4 dat)
2) How to force the file opener to execute the Excel VBA (Suppress the Macro Warning)?
it has something to do with security level
if security level is set to High den there will be a warning and if it is low den d macro will run without any warning
http://office.microsoft.com/en-us/assistance/HA011403071033.aspx