The error only occurs during closing and when run with excel 2007 but not 2003. When I try to debug it the file closes immediately and the error line is on shown as a brief flash. I think is flashes on the line:
“ .Controls("Add Watch").Visible = True “ line
Can any one help please.
The complete code is:
Please Login or Register to view this content.
Hello cdt,
Welcome to the Forum!
I would first check the menu captions for Excel 2007 and make sure they match in spelling and capitalization.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi All,
Thank you for responses, I did try to 'step through' the VBA code but was still unable to fix the problem.
However I have fixed it now by including appropriately placed error trapping code (On Error Resume Next and On Error GoTo 0)
So problem [SOLVED]
Last edited by romperstomper; 12-08-2010 at 09:01 AM.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks