Excel Protection

[CraigWolfenden]

Hello There,

I have designed a spreadsheet which is nearly ready to be deployed nationally.

However I wish to protect the code etc in the spreadsheet but I have a few problems I need to get around.

The spreadsheet is designed so a user places a number in cell A5, in turn this number is referenced to a Master Sheet, and the remainder of this row is completed.

The user then moves to B5 and repeats the action.

As the cells contain varying text depending on the number entered I have created an Excel Macro button to automatically format the rows to the correct size using Format -> Row -> Auto-Fit.

My problem is if I enable Protection (Tools -> Protection -> Protect Sheet) the auto-height will not work forcing me to leave the code open for anyone to modify.

Can anyone help me with this problem.

Thanks in advance.

 

[VoG]

Try like this

ActiveSheet.Unprotect password:="pw"
'
'your code
'
ActiveSheet.Protect password:="pw"

 

[CraigWolfenden]

Hello and thank you for your reply.

Are you suggesting I add a line to the code of the macro to unprotect the spreadsheet, then run auto format then protect it again?

Once again thank you for your reply.

 

[VoG]

Yes, exactly.

 

[CraigWolfenden]

That worked brilliantly, thank you very much.