Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
If you post it (your code)..........someone will help
Vaya con Dios, Chuck, CABGx3 "Derek Upson - Pioneer" wrote: I have a spreadsheet model. Within the model are a bunch of fields requiring input. I wanted to have a macro that would clear all of these fields so someone could start over. That was the easy part. However, I don't want someone to click on the button that starts the macro by accident (wiping out everything already done). Therefore, I want to add a pop-up box to the beginning of the macro that asks the user to verify that they want all contents cleared. Can someone help me understand how this can be added to the macro? Thanks in advance. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
i sent a reply with my excel spreadsheet attached and it did not go through.
are attachments restricted in this newsgroup? "CLR" wrote in message ... If you post it (your code)..........someone will help Vaya con Dios, Chuck, CABGx3 "Derek Upson - Pioneer" wrote: I have a spreadsheet model. Within the model are a bunch of fields requiring input. I wanted to have a macro that would clear all of these fields so someone could start over. That was the easy part. However, I don't want someone to click on the button that starts the macro by accident (wiping out everything already done). Therefore, I want to add a pop-up box to the beginning of the macro that asks the user to verify that they want all contents cleared. Can someone help me understand how this can be added to the macro? Thanks in advance. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I don't know about "restricted", but they are not desired......just copy and
paste your code, or take a look at Mike's suggestion...... Vaya con Dios, Chuck, CABGx3 "Derek Upson - Pioneer" wrote: i sent a reply with my excel spreadsheet attached and it did not go through. are attachments restricted in this newsgroup? "CLR" wrote in message ... If you post it (your code)..........someone will help Vaya con Dios, Chuck, CABGx3 "Derek Upson - Pioneer" wrote: I have a spreadsheet model. Within the model are a bunch of fields requiring input. I wanted to have a macro that would clear all of these fields so someone could start over. That was the easy part. However, I don't want someone to click on the button that starts the macro by accident (wiping out everything already done). Therefore, I want to add a pop-up box to the beginning of the macro that asks the user to verify that they want all contents cleared. Can someone help me understand how this can be added to the macro? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pop-up when running a macro | Excel Discussion (Misc queries) | |||
Event Macro running another macro inside | Excel Discussion (Misc queries) | |||
Running one macro from another | Excel Worksheet Functions | |||
disable user running macro from Tools Macro | Excel Discussion (Misc queries) | |||
Running VBA Macro | Excel Discussion (Misc queries) |