| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro's doesn't work (in potected Sheets)
When I protected my sheets.
The macro's will give a lot of Errors, in unprotected mode the macro's work perfect. Error section is in bold: Sheets("Venders").Select ActiveSheet.Unprotect Range("E5").Select Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False Why? what I'm doing wrong? I changed Paste mode, I checked the space etc. Thanks for any support Ruud |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| work sheets | Excel Discussion (Misc queries) | |||
| Macro's not appearing in new spread sheets | Setting up and Configuration of Excel | |||
| Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
| Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
| I wish to save my Excell work in my work sheets | Excel Worksheet Functions | |||
![Ruud[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
