Search results for query: *

Can anyone tell me if it is possible to have two different types of formats on one cell? For example if I enter 100%, do a percent formula and if I enter 100 I do an integer value formula.

Heres the issue, I have a excel spreadsheet that has 5 sheets. On one of the sheets there is a checkbox, when the checkbox is checked, two different sheets need to do the same thing. Both sheets have locked cells, with different formatting. I need to unlock each cell and allow all users to...

Hi everyone, First off I just wanted to say that this is GREAT, I have gotten so much good advice that I cant thank everyone enough. Ok here is the problem, I have a cell on my spreadsheet, which if empty when the sheet is opened. I want the cell to change its color when a user goes in and...

Hi, I have a excel spreadsheet that when opened asks a user to login. I want the Cancel button not to be enabled when the user opens the file for the first time but after that the cancel button should be disabled. Is that possible?

Hi everyone, Can someone help with this small issue, I need to change the cell color if a value is changed after the first value has been saved to the database. Thanks

Hi everyone, Could anyone tell me how to create a Save As dialog box to pop up when a user clicks on a custom made menu option in excel. I have menu option called Check In, when a user clicks it a popup should display like a save as option. The user then can choose to save the excel file in...

Hi Everyone, Here is my problem, I has windows xp installed and work on my excel worksheet using excel 2000. I upload the spreadsheet to our website to allow users to download this as a templete to complete their work which is then saved to the database. Now the problem is if a user has...

Hi Everyone, Here is my issue. I have a excel work book that has 5 sheets. On one of the sheets there is a checkbox, when the checkbox is checked I need to unprotect cells to allow the users to update it in a different sheet in the workbook. As VBA is new to me, can anyone give me some...

Hi Everyone, I have a excel spreadsheet that has a list box. If a user has already selected a value from the list the cell then should NOT be updateable but if the user has not selected any value then he/she should be able to update the cell. I just have no idea how to get it done. Any...