Posted to microsoft.public.excel.programming,microsoft.public.excel

mantrid

external usenet poster

Posts: 15

using VBA on protected sheets, is it possible?

Hello
I am having problems using the VB code below (which basically copies and
inserts a row) to work on a protected sheet, despite the protection being
set to allow insertion of rows. It works fine when sheet is unprotected. Is
there a way around this

With ActiveSheet
..Rows(rowno - 1).Copy
..Rows(rowno - 1).Insert (xlShiftDown)
..Paste Destination:=ActiveSheet.Rows(rowno)
End With

Thanks
Ian

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Protected Sheets	Ann	Excel Worksheet Functions	2	March 30th 10 11:09 PM
protected sheets	Jock	Excel Worksheet Functions	3	December 4th 07 12:51 PM
Macro for filter on protected workbook that works for all sheets, no matter what sheets are named?	StargateFanFromWork[_3_]	Excel Programming	6	January 26th 06 06:31 PM
Protected sheets	HRMSN	Excel Worksheet Functions	1	November 8th 05 10:19 PM
Protected sheets	Rob	Excel Programming	0	January 19th 04 06:51 PM

All times are GMT +1. The time now is 01:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us