Link to home
Start Free TrialLog in
Avatar of howardching
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)?
Avatar of hiteshgupta1
hiteshgupta1

i dunn have the exact idea of how to disable a menu button
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
ASKER CERTIFIED SOLUTION
Avatar of mvidas
mvidas
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
why only mvidas??