Protection + Macro = NOTHING!
 

Here's the sheet: 'Click' (http://www.admasu.karoo.net/techsolution
(Friday 30th April).xls)

OK, so here's my problem. I've just finished a workbook and now I'
testing it through. I have a macro on the "Add Stock" sheet tha
inserts a row in the "motherboard" sheet, pastes the info in there an
uses an offset thingy to create an ID that follows on from the previou
ID number. But it comes up saying:
[image: http://www.admasu.karoo.net/images/shot2.JPG]

I have protection on all the cells but the ones where you enter text
it is a range that the user can edit.

What do I do to solve it? My project is in on Friday!!

edit: the password for protection is just 12

--
Message posted from http://www.ExcelForum.com