LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Insert Rows in Protected Worksheet

I have a simple macro where the data is manipulated and
then the file is protected and saved as a new file. Then
looped to repeat multiple times. I want the user of the
new file to be able to insert rows. I see that Excel has
several check boxes in the protection function; however,
the ability to insert rows does not carry to the new
file. What is the code to allow this in the newly
created protected file?

Thank you for your help
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert/ Delete rows of a protected worksheet. quest4rachit Excel Discussion (Misc queries) 3 July 16th 09 01:02 PM
Allow Insert Rows in a protected worksheet andrew-k Excel Discussion (Misc queries) 2 June 4th 09 06:33 AM
How do you insert & delete rows in a protected worksheet? Tiffany G. Excel Worksheet Functions 1 February 3rd 09 01:26 AM
Allow user to insert rows on protected worksheet sblock Excel Discussion (Misc queries) 1 November 14th 08 09:46 PM
shared workbooks - protected worksheet - insert rows mika. Excel Programming 1 September 11th 03 01:51 AM


All times are GMT +1. The time now is 03:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"