| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reference to another sheet not in wkbk brings up dialog box
I have a macro that writes a formula referencing another sheet in the
workbook. When this sheet isn't in the workbook, Excel opens the dialog box to find the sheet and repeats for every line that contains the reference. I would like to add something around the section referring to another sheet to bypass that section if the sheet is not in the workbook. Is this possible? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
reference to another sheet not in wkbk brings up dialog box
Valeire
Dim ShtName As String 'Other Code On Error Goto NoSheet: ShtName = Worksheets("Sheet that may not be there").Name 'Code for formula referencing NoSheet: 'Finish up code HTH, Bernie MS Excel MVP "Valerie" wrote in message ... I have a macro that writes a formula referencing another sheet in the workbook. When this sheet isn't in the workbook, Excel opens the dialog box to find the sheet and repeats for every line that contains the reference. I would like to add something around the section referring to another sheet to bypass that section if the sheet is not in the workbook. Is this possible? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
reference to another sheet not in wkbk brings up dialog box
Perfect!! Thanks so much!
"Bernie Deitrick" wrote: Valeire Dim ShtName As String 'Other Code On Error Goto NoSheet: ShtName = Worksheets("Sheet that may not be there").Name 'Code for formula referencing NoSheet: 'Finish up code HTH, Bernie MS Excel MVP "Valerie" wrote in message ... I have a macro that writes a formula referencing another sheet in the workbook. When this sheet isn't in the workbook, Excel opens the dialog box to find the sheet and repeats for every line that contains the reference. I would like to add something around the section referring to another sheet to bypass that section if the sheet is not in the workbook. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Hyperlink from 1 WKBK to open another WKBK and activate | Excel Programming | |||
| Large wkbk won't recalc after moving sheet | Excel Discussion (Misc queries) | |||
| How can I look for a sheet in a wkbk and run a macro if not there | Excel Programming | |||
| How do I replicate an area of a SS onto another sheet in same wkbk | Excel Discussion (Misc queries) | |||
| print prevu button brings rights management dialog box - how do i | Setting up and Configuration of Excel | |||
Linear Mode
