Help changing color of cells on button click

[LePig]

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

Please Login or Register  to view this content.

It is giving me a

run time error 1004

Application-Defined or object-defined error

Any ideas or help much appreciated.

Thanks in advance

[Arkadi]

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.

[zbor]

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)

[Mumps1]

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.

[LePig]

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

[zbor]

Please go in the first post and edit as described.

[LePig]

apologies all done

[zbor]

Thank you. Hope you'll get your answer soon.

[LePig]

How do i attached the file?

[zbor]

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

remember to overwrite all private informations.

[Arkadi]

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.

[LePig]

I have attached the file now at the top - i tried your remover but it seems not to remove sheet2?

[Arkadi]

Indeed, haven't seen that before... it has no name but also different icon

Ill get back to you.

[LePig]

I think that is what is causing the problem because the code works fine in a new file

[Arkadi]

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.

[LePig]

will that also copy all of my conditional formatting?

[LePig]

will it also copy all of my conditional formatting?