I'll be honest in that I'm not entirely sure exactly what I'm looking for.. So, I'll say what I've got right now and what I want to ultimately achieve:
I have a time sheet spreadsheet with 5 tabs, one for each day of the week... All sheets are identical except for the day and date. There is a list of names with conditional formatting that will change the background color of the cell based on the time entered in other columns. The conditional formatting is perfect if being used simply in the Excel spreadsheet. However, I want this data to be available on other computers, but without editing abilities. So, basically, the spreadsheet will be constantly open on 1 computer with the ability to edit.. Other people may open the spreadsheet on their computer, but should not be able to edit it. I thought of saving it as a Web Page in a folder that everyone has access to.. That seemed to work fine, but then I added a button with a macro assigned to it. That all works great in the spreadsheet too.
However, (And it seems as though this started happening after I added the macro/button) when I save the spreadsheet as a web page and then open the web page in FireFox, it looks exactly how it did when I saved it. When I open the web page as an Excel document and press the button to add the time (which is what the macro does), it adds the time, but the cell color does not change. I believe it has removed my conditional formatting. I don't know if the button/macro is the cause, but I do know that before I added it, after published as a web page, the conditional formatting was working.
I'm new at this, so I apologize if I was too descriptive or not descriptive enough. I'm happy to give more information.
Thanks in advance
I have a time sheet spreadsheet with 5 tabs, one for each day of the week... All sheets are identical except for the day and date. There is a list of names with conditional formatting that will change the background color of the cell based on the time entered in other columns. The conditional formatting is perfect if being used simply in the Excel spreadsheet. However, I want this data to be available on other computers, but without editing abilities. So, basically, the spreadsheet will be constantly open on 1 computer with the ability to edit.. Other people may open the spreadsheet on their computer, but should not be able to edit it. I thought of saving it as a Web Page in a folder that everyone has access to.. That seemed to work fine, but then I added a button with a macro assigned to it. That all works great in the spreadsheet too.
However, (And it seems as though this started happening after I added the macro/button) when I save the spreadsheet as a web page and then open the web page in FireFox, it looks exactly how it did when I saved it. When I open the web page as an Excel document and press the button to add the time (which is what the macro does), it adds the time, but the cell color does not change. I believe it has removed my conditional formatting. I don't know if the button/macro is the cause, but I do know that before I added it, after published as a web page, the conditional formatting was working.
I'm new at this, so I apologize if I was too descriptive or not descriptive enough. I'm happy to give more information.
Thanks in advance