| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Obj Variable or withblock variable not set?
On Feb 11, 1:51*pm, "Jim Cone" wrote:
You haven't told Excel what wksSummary refers to... Set wksSummary = ActiveSheet -or- Set wksSummary = Worksheets("Summary"). However, if CommandButton1 is on Summary sheet and the code is in that sheet's module then this will work... ("Me" is a reference to the sheet containing the module) '-- Private Sub CommandButton1_Click() Const PWORD As String = "dave" Me.Unprotect password:=PWORD Me.Range("B:C").ClearContents Me.Range("A1").Select End Sub '-- Jim Cone San Francisco, USAhttp://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "davegb" wrote in message 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? Doh! Thanks, Jim. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Object variable or withblock variable not set | Excel Programming | |||
| Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| Run-time error '91': "Object variable or With block variable not set | Excel Programming | |||
| Cells.Find error Object variable or With block variable not set | Excel Programming | |||
![davegb[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
