Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've created a button linked to several calculations. It begins by
calculating a percentage. Then I figure the dollars with that figure. Then I figure the difference between the original dollar amt and the new dollar amt. Then I copy this into the cells I want it to stay. I have 4 buttons I'm using to cover 4 possible scenarios. They're all set at "Percent - Dollar - Dollar" (and they're all set up to run via macro tied to the buttons. Now, on some, when I click the button it's changing my first dollar to a percent. Why would it do that and how can I prevent it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
Can you lock the format of a cell and still change content | Excel Worksheet Functions | |||
Lock cell formats (conditional format) | Excel Worksheet Functions | |||
Conditional Format To Lock Cell | Excel Discussion (Misc queries) | |||
Is there a way to lock out the format for the cell and still allow data entry and C&P? | New Users to Excel |