I have an excel database with hidden worksheets to make notes on. I have been using this code to pull up the hidden sheet and then hide it again when I click off of it.
Please Login or Register to view this content.Please Login or Register to view this content.
This code has now stopped working and gives the error runtime error '424' object required.
As far as I know I haven't changed anything so I cant understand why it has suddenly stopped working.
Last edited by alansidman; 12-11-2015 at 12:07 PM.
Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html
(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
When you run and get the error message, click on debug and tell us which line is highlighted.
With Evaluate(Target.SubAddress).Parent
this is the highlighted line
Tried your code and cannot replicate the error message. Here is a link to explain the error message, however.
https://msdn.microsoft.com/en-us/lib.../gg251554.aspx
Thanks, but I still don't understand how to correct this error, or why it has suddenly stopped working when it was fine before and nothing has changed.
I have tried removing all the code saving & closing the doc then re-entering it again but I still get the error code.
What's the value of Target.SubAddress when you get the error?
If posting code please use code tags, see here.
Im not sure what exactly you mean. This is what I see
Doc1-page-001.png
What does this display when you add it before the line that causes the error?
Please Login or Register to view this content.
When I add that and try to follow the link I get this message,
'3'!r1c1
And the MsgBox Target.SubAddres is highlighted in the debugger
What happens if you use Range instead of Evaluate?
Please Login or Register to view this content.
i Get an error message saying
run-time error 1004:
Method 'range' of object '-worksheet' failed
Do you have a sheet with the name '3'?
Yes, I have 950 hidden sheets, each sheets name is the a number, so 950 sheets named 1,2,3,4 etc...
The only way I can replicate the error you describe is if I don't have a worksheet named exactly '3' in the active workbook.
What happens when you enter this in the immediate window (CTRL+G)?
Please Login or Register to view this content.
I just get a message saying the reference is not valid.
The only things that show up in that window are the one sheet that is constantly visible and table 1 (the table within the visible sheet)
What's the actual error message?
'the reference is not vailid'
That's the error message when you enter this in the immediate window?
Are you sure you have a worksheet with the exact tab name '3'? No leading/trailing spaces?Please Login or Register to view this content.
Any chance you could upload a sample workbook?
Click on GO ADVANCED and use the paperclip icon to open the upload window.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks