Macro to exit spreadsheet file
Macro to exit spreadsheet file
(OP)
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
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





RE: Macro to exit spreadsheet file
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
www.motagg.com
RE: Macro to exit spreadsheet file
RE: Macro to exit spreadsheet file