Password protect macros

**ripps** · 06-12-2008, 06:26 AM

Hi

1st post on these forums.

I recorded a couple of macros on excel last night, one hides certain rows then sorts by columns E and B then hides certain columns and protects the sheet. The other does pretty much the opposite, unprotects the sheet then unhides the columns, sorts by columns B and E then unhides the rows.

My question is can I password protect the macro button so only authorised people can use it?

The reason being the hiden rows and columns need to stay hidden and only certain people able to unhide them due to there being sensitive information on them.

If theres no way of password protecting this any ideas on how I can keep these rows and columns from being unhidden by unauthorised people would be a great help.

Thanks in advance for any help provided.

**royUK** · 06-12-2008, 06:40 AM

Welcome to the Forum. You could add this to the start of your code

Please Login or Register  to view this content.

**broro183** · 06-12-2008, 06:46 AM

hi all,

Roy, you just beat me to this one!

Ripps, Roy's suggestion will work for you but depending on how sensitive the information is & what skill level your Excel users have, this may not be sufficient protection - see the below link for further info on security within Excel:

http://www.j-walk.com/ss/excel/faqs/protectionFAQ.htm

hth,
Rob

**ripps** · 06-12-2008, 06:55 AM

Thanks alot guys. I will have a look over the info you have provided and give it a go later. Will update you when had the chance.

Thanks for the warm welcome also!

**ripps** · 06-12-2008, 07:55 AM

Originally Posted by royUK

Welcome to the Forum. You could add this to the start of your code

Please Login or Register  to view this content.

This works really well apart from when the password box comes up, if you press cancel the same thing happens as if you put the password in. I entered the desired password in the <> signs but is there anything else i need to so?

Sorry I only have very basic knowledge of macros. Otherwise this would be perfect for what I need.

**hutch@edge.net** · 06-12-2008, 09:42 AM

Morning, ripps.

I'm a vba newbie myself, but in the absence of a guru you may try this.

First, replace "secret" with your password. This is the constant the macro is looking for in order to continue running the code.

Leave the reaminder of the code the way it is. The <> symbols are actully less than and greater than symbols, telling the macro to exit if anything other than your password is entered.

I'm sure that if I'm wrong one of the mods will correct me.

Have a good one.