Obj Variable or withblock variable not set?

Posted to microsoft.public.excel.programming

davegb[_2_] davegb[_2_] is offline

external usenet poster

Posts: 72

Obj Variable or withblock variable not set?

This is the code:

Private Sub CommandButton1_Click()
Const PWORD As String = "dave"
Dim wksSummary As Worksheet

wksSummary.Unprotect password:=PWORD <---- OBJ VAR NOT SET
Range("B:C").Select
Selection.ClearContents
Range("A1").Select

End Sub

This worked fine in a previous macro, but not today. Any ideas why
it's not recognizing wksSummary or password? Or is it something else?

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
Object variable or withblock variable not set	davegb	Excel Programming	3	October 18th 05 02:57 PM
Sum cells based on a row variable and seperate column variable	CheeseHeadTransplant	Excel Worksheet Functions	10	September 23rd 05 06:59 PM
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel?	Daniel	Excel Worksheet Functions	1	July 9th 05 03:05 AM
Run-time error '91': "Object variable or With block variable not set	Mike[_92_]	Excel Programming	2	December 30th 04 10:59 AM
Cells.Find error Object variable or With block variable not set	Peter[_21_]	Excel Programming	2	May 8th 04 02:15 PM

All times are GMT +1. The time now is 09:42 AM.

Menu

About Us