Adding a macro that will work even when the sheet or workbook is protected (locked)

Morning all,

Another question for you.

I'm creating a timesheet for contractors to use to record their location and working hours. They will be using a netbook, so figured it would be good if I can make the timesheet as small as posible.

I thought it would be a good idea to add a macro that when pressed created another row.

All was going well, and the macro worked perfectly, right up until i locked the sheet. Now the Macro doesn't work at all.

Any ideas on how I can get around this little hickup?

Many Thanks,


Will

Many thanks for all your help gents.

Sorry for the late reply!

You earned it kiddo *said in a Michael Buble style* lol - Don't take that the wrong way!

Originally Posted by TMShucks

What way would that be?

Ohhhh Don't worry

Originally Posted by TMShucks

Not worried. Intrigued. I have no idea what a "Michael Buble style" is.

You know who Michael Buble is surely....It sounded funny in my head lol

Originally Posted by TMShucks

He's a man. He's a singer. He's got a c r a p website. Can't really say I've seen or heard much of him. Probably wouldn't recognise him without subtitles or an introduction. I'm sure I've heard him sing but no idea, in all honesty, what he sounds like. My knowing nothing about him doesn't seem to have affected his fame.

So, like I said, no idea what a "Michael Buble style" might look or sound like. But the fact that I "shouldn't take it the wrong way" implies that I might, and I wouldn't like it


Regards, TMS

Well, he's...how can i put it, supposed to be very sophisticated, cool headed and able to charm any woman. Me saying 'Kiddo' and maybe saying what I said in a way he might say it (in my head anyway), could sound condescending.

Originally Posted by jaslake

You're welcome...glad I could help. Thanks for the Rep.

No problem jaslake!

Haha, I think that's a good shout TMShucks! Thanks again for the help.

P.s. - Genuinely wasn't trying to offend! lol