|
|
|
|
#1
02-09-2016, 08:19 PM
|
|||
|
|||
Okay I just realized it had this in there If ActiveWorkbook.ProtectStructure = True Or _
My_Range.Parent.ProtectContents = True Then MsgBox "Sorry, not working when the workbook or worksheet is protected", _ vbOKOnly, "Copy to new workbook" Exit Sub End If Guess that explains why it won't work on protected =) DOH! 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Tables: Ensuring Rows Not Split Across Pages Yet Retaining Repeated Header
|
Andrew H | Word | 5 | 12-28-2014 06:08 PM |
| how can i split a column of rows in half without copy and paste.. | Lindseyfparker | Excel | 2 | 04-25-2014 12:52 AM |
| Macro Winword mailmerge split printpage with mergefield as filename | pca | Word VBA | 2 | 02-28-2014 02:43 PM |
| Losing rows when pasting split cells | Gitley | Word Tables | 1 | 01-15-2013 07:49 AM |
| How to auto-split a table at FULL rows? | pstein | Word | 5 | 03-27-2012 02:48 PM |
Windows XP 
Office 2013
Hybrid Mode