Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Locking commands

2 views

Skip to first unread message

unread,

Dec 19, 2003, 11:55:19 AM12/19/03

Hi!

I was wondering how I could prevent the user from changing
certain fields after a macro is run on a spreadsheet.

For example after the macro is ran:
The user can't:
insert/delete rows or columns
change certain cells/rows/columns values

Thank you,
LC

unread,

Dec 19, 2003, 12:41:38 PM12/19/03

It sounds like your macro should protect the worksheet. And maybe lock some
cells before the protection.

You can lock a cell by selecting it, format|cells|Protection tab|

And you can protect a worksheet by Tools|Protection|protect sheet.

(and if you want your macro to do it, record a macro when you do it once and
steal that recorded code.)

That said, worksheet protection is very weak. There's code posted here every
day/week that would unprotect the worksheet.

0 new messages