ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   For Tom Ogilvy (https://www.excelbanter.com/excel-programming/372579-tom-ogilvy.html)

JLGWhiz

For Tom Ogilvy
 
Ref: Posting about the msoShapes not being visible while all others were.

I still don't know what the specific problem was but it finally went away.
I made sure that all data was cleared from the worksheets and all userforms
were deleted from the code module. At this point the problem was still
there. I deleted all code except the one sub to call the msoShape. It still
would not appear. I deleted the code module and inserted a new module and
now it works like it is supposed to. I decided the best thing to do was to
delete the workbook and forget it until it crops up again.

This was a highly unusual anomaly that made absolutely no sense since the
ThisWorkbook properties window showed -4104-xlDisplayShapes.

Thought you would like to know since you were the only one who bothered to
respond.

Tom Ogilvy

For Tom Ogilvy
 
Thanks.

--
Regards,
Tom Ogilvy

"JLGWhiz" wrote in message
...
Ref: Posting about the msoShapes not being visible while all others were.

I still don't know what the specific problem was but it finally went away.
I made sure that all data was cleared from the worksheets and all
userforms
were deleted from the code module. At this point the problem was still
there. I deleted all code except the one sub to call the msoShape. It
still
would not appear. I deleted the code module and inserted a new module and
now it works like it is supposed to. I decided the best thing to do was
to
delete the workbook and forget it until it crops up again.

This was a highly unusual anomaly that made absolutely no sense since the
ThisWorkbook properties window showed -4104-xlDisplayShapes.

Thought you would like to know since you were the only one who bothered to
respond.





All times are GMT +1. The time now is 07:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com