Disable save function

[Guest]

I have multiple users for a template. The users need access to modify
values, but not formulas. I need to prevent any users from saving without a
password (as ineffective as they may be). I only want to grant "save as"
capabilities. Any help would be appreciated.

Thanks,
JB

 

[Guest]

Have a look here:
http://www.ozgrid.com/forum/archive/index.php/t-12669.html

Hope that helps!

 

[Jack Sons]

TazGuy,

I read this

"I wrote this in ExcelXP, but you should get an idea of what you need to do.
Each control has a number assigned to it, and you would need to know that
number to disable it."

From where come the numbers of the controls? Has each menu item and every
button its own control number? Where can we find those numbers?

Jack Sons
The Netherlands

 

[Ron de Bruin]

Hi Jack

Use the ID number
See
http://www.rondebruin.com/menuid.htm