Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Used J-Walks Menu maker to create menu of frequently used Spread-Sheets.
This add-in will be sent to all our salesmen. The menu lists ALL of the available Sp.Sheets, BUT not every salesman gets every Sp.Sheet. When a non-existant Sp.Sheet is selected from menu, error message pops up: "C:\ .................... (file Name), could not be found. Check spelling ................ I'd like to NOT have this message come up, but replace it with a custom message, something like: The requested file is not on your available list. Please select the correct template. Therefo Can I deactivate/delete the VBA message? If yes, How? How can I program in a message that tests for the requested Sp. Sheet, and selects the Sp. Sheet, if exists, or else comes up with my custom message? I hope this makes sense. Help!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Views Error Message | Excel Discussion (Misc queries) | |||
Replace Excel Message w/Custom Message | Excel Programming | |||
Intercept/replace standard 'cell protected' message with my own message? | Excel Programming | |||
Error Message When Using Replace | Excel Programming | |||
Why error message when trying to display custom view? | Excel Discussion (Misc queries) |