MS Visual Basic Error

  • Thread starter Thread starter John
  • Start date Start date
J

John

I opened an excel spreadsheet that I created and received
an MS Visual Basic error that says the following in red:
Private Sub New Request
_Click()

End Sub

An error box also appears:
Compile error:
Expected: identifier
[OK]


Any ideas what might be causing this? I'm thinking that
something might be wrong with a check box that was
created with the name "New Request" next to it.

Your help is greatly appreciated.
 
Right click on the worksheet that holds this checkbox.
Select View Code
If that's the only thing you see, you can delete it.
click on that window
Ctrl-A to select all the text
hit the delete key to wipe it out.

If you have other macros that you want to keep, don't do this.

Just delete the "private Sub....End Sub" portion.

You may want to look at Deb Dalgleish's site (it has some pictures that might
help explain more):

http://www.contextures.com/xlfaqMac.html#NoMacros
I opened an excel spreadsheet that I created and received
an MS Visual Basic error that says the following in red:
Private Sub New Request
_Click()

End Sub

An error box also appears:
Compile error:
Expected: identifier
[OK]

Any ideas what might be causing this? I'm thinking that
something might be wrong with a check box that was
created with the name "New Request" next to it.

Your help is greatly appreciated.
Click to expand...
 
Back
Top