Macro to exit spreadsheet file

[tashu]

Hi,

I was wondering if any of you can help me with VBA code or else so i can add a button wth macro function on it which will automatically close the spreadsheet system open.

and i am not sure whether this is possible or not
BUT can we password protect macros? So that if we have to run certain macro, it should ask us for some password before it runs or carry out its function.


Thanks
your help will really be appreiciated

 

[rtmote]

To close worksheet by macro, use worksheet_deactivate()

If the macro is on the sheet and the sheet is protected, the macro cannot run as the macro cannot activate the sheet to perform.

Robert Mote

http://www.motagg.com

 

[cummings54]

Here's some sample code you can try to protect a macro with a password. Enjoy

 

[cummings54]

Whoops! forgot the spreadsheet link