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 run:
The user can't:
insert/delete rows or columns
change certain cells/rows/columns values

Thank you,
LC

Try this:
ActiveSheet.Protect (userinterfaceonly)

You have to lock certain cells ahead of time, which you can do manually.
Then, when activesheet.protect is run, users can't modify things. The
userinterfaceonly option allows subroutines to continue w/
modifications.

Cells.Locked = True
might be usefull too. I believe that it will allow you to do the
locking of certain cells from a subroutine.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

And one reply from you post of a couple days ago:

http://groups.google.com/groups?thre...764D%40msn.com

LC wrote:

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 run:
The user can't:
insert/delete rows or columns
change certain cells/rows/columns values

Thank you,
LC

--

Dave Peterson