Thread: Macro's doesn't work (in potected Sheets)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ruud[_2_] Ruud[_2_] is offline
external usenet poster
  
Posts: 7
Default 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


Reply With QuoteReply With Quote