Hi,
I am having problems changing the cell color on button click.
I want the cells to be invisible/white when the file opens but when i click a button for the cell to change color.
Please see code below
It is giving me a
Please Login or Register to view this content.
run time error 1004
Application-Defined or object-defined error
Any ideas or help much appreciated.
Thanks in advance
Last edited by LePig; 08-26-2016 at 09:32 AM.
Sounds like one of the sheets might not exist? Verify the exact name of Quotation Form and Sheet21, including any leading or trailing spaces? Otherwise maybe attach the workbook.
Please refer to forum rule #3 regarding code tags when posting code.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
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 here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
You are using "interior.colorindex" which refers to the background color of the cell not the color of the font. To make the text white(invisible), you need to use something like this:Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Apologies for not conforming with code tags.
The sheet exists because it recognises the first argument and will put out the msgbox - i can make the code work in a new file it will not work in my original file that contains lots of other code.
For some reason yesterday in my project explorer my sheet jumped to sheet21 and a new blank sheet went in at sheet2, i want to delete it so i can rename quotation form as sheet2.
Do you know how or if i can delete a sheet out of the project explorer - as the sheet does not exist in my workbook?
Thanks in advance
Please go in the first post and edit as described.
apologies all done
Thank you. Hope you'll get your answer soon.
How do i attached the file?
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
remember to overwrite all private informations.
I'm assuming when you say Sheet2 does not exist in workbook you mean it does not show on the bottom tabs? But you do see it in the project explorer? It may be hidden, or even "very hidden" which would mean it doesn't show even when you select the "unhide" option. In the project explorer is is called "Sheet2" ?
You can just use a mini macro to delete it and then you can delete the code again.
Please Login or Register to view this content.
I have attached the file now at the top - i tried your remover but it seems not to remove sheet2?
Indeed, haven't seen that before... it has no name but also different icon
Ill get back to you.
I think that is what is causing the problem because the code works fine in a new file
Yeah, it looks like a workbook object based on the icon, but no idea how to remove it unless it has something to do with references...
You may just want to copy all the sheets and code to a new book.
will that also copy all of my conditional formatting?
will it also copy all of my conditional formatting?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks