Excel / protecting worksheet with macro

**Denz_711** · 03-17-2013, 12:38 PM

Worksheet can be protected with macro but once the macro is run and reprotect the worksheet it can be simply open by simple click of unprotect menu , is there any other way that we could protect the worksheet...with macro it's like the worksheet is unprotected .

**HaHoBe** · 03-17-2013, 12:52 PM

Hi, Denz_711,

have you set a password for the protection which must be used to unprotect the worksheet as well?

Ciao,
Holger

**Denz_711** · 03-18-2013, 01:08 AM

Originally Posted by HaHoBe

Hi, Denz_711,

have you set a password for the protection which must be used to unprotect the worksheet as well?

Ciao,
Holger

" Yup ...the worksheet is protected with password but once you run a macro to unprotect it you will be required to input a password and same time before closing macro can protect it again... which correct routine . the problem is that the protected worksheet is now volatile and can be easily unprotect with a click of unprotect menu ...hence it will not ask for a password and the worksheet will just simply open unprotected. "

**HaHoBe** · 03-18-2013, 01:29 AM

Hi, Denz_711,

please do not quote whole postings, see the [url=http://www.excelforum.com/forum-rules/642590-forum-rules.html]Forum Rules/url] for more information.

As I do not know why you need to unprotect the sheet: have you considered using the parameter UserInterfaceOnly:=True to run macros on the sheet without unprotecting it? Please note that this is a volatile setting (will not be saved with the workbook so needs to be put either in the Workbook_Open and/or Worksheet_Activate event).

Is the version Excel2003 the one you use like stated in your profile?

Ciao,
Holger

**Denz_711** · 03-18-2013, 01:50 AM

Thanks Holger for your reply ... I'm using mixed version of excel 2003...2007..etc. which ever terminal I'm in the company and at home and the only things it has same result .. I did not still try to use userInterfaceOnly:=True , but yup I need to protect the worksheet after using macro. Hence without macro worksheet can be protected by password but with macro run on the sheet ... it's can be open easily ... and it will not ask a password . Maybe there is still some way around to protect the sheet with password ??? need to protect those formula on the sheet from unexperienced user..