View Single Post
  #3   Report Post  
cjfuqua
 
Posts: n/a
Default

Thank you Bob ... I just checked and the ONLY thing there is this:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) End Sub

It looks like all of my Macros are missing ... Now what ...???

Thanks ... CJ

"Bob Phillips" wrote:

It sounds like there is some code them hides all the bars, and then goes
through making some visible. Probably trying to make Worksheet Menu Bar
visible and failing.

You need to go into the VBE (Alt-F11), see what projects are in there, and
check the ThisWorkbook for some startup code. Post back when you have more
details.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"cjfuqua" wrote in message
...
When I came to work tonight and opened up Excel, I received a runtime

error
in Visual basic ... It said "run-time error"-2147467259(80004005)': Method
"Visible" of object "CommandBar' Failed"

I clicked End on the runtime error, and Excel came up ... but all the Tool
Bars are missing ... I can't save or print any files ...

Any suggestions on how to fix this ...???

Thanks ... CJ