can someone help me with a macro that will perform the following functions on my excel work book
1. force user to enable macro. that is hide all work sheet if macro is disabled except a welcome page informing the user on how to enable macro
2. if macro is now enabled, prevent user from using "save as" function but can only save
3. prevent user from deleting or editing any cell that contains formula except with a password let say "zebra"
4.add an expiry date to the work book if possible with a warning message reminding the user of the date e.g 25 December 2011 .
if all these can be combined into one macro , help me with the code please
or if separately , guide me
iam still new to macros
thanks in advance
1. force user to enable macro. that is hide all work sheet if macro is disabled except a welcome page informing the user on how to enable macro
2. if macro is now enabled, prevent user from using "save as" function but can only save
3. prevent user from deleting or editing any cell that contains formula except with a password let say "zebra"
4.add an expiry date to the work book if possible with a warning message reminding the user of the date e.g 25 December 2011 .
if all these can be combined into one macro , help me with the code please
or if separately , guide me
iam still new to macros
thanks in advance
