Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if the first sheet is the selected sheet
Hello everyone,
I have a program that opens an excel template and then checks to see if the first sheet is selected, if it is then no error but i get an error irrespective of the fact whether the first is selected or not...i am pasting the code here and would appreciate it if someone can point what i am missing. TIA #region Excel Check 5: First sheet or multiple sheets selected if(OptionsData.XLCheckSelectedSheet)----(bool) { if(XLwb.Sheets.Count 1 && XLwb.ActiveSheet != XLwb.Sheets.get_Item(1)) { ErrorCounter++; ProcessError(ErrorCounter, "The first sheet is not the selected sheet"); } |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if the first sheet is the selected sheet
why dont you activate the first sheet after opening the file. This will
solve the problem of error because you then dont need to have this code in your workbook. melody wrote: Hello everyone, I have a program that opens an excel template and then checks to see if the first sheet is selected, if it is then no error but i get an error irrespective of the fact whether the first is selected or not...i am pasting the code here and would appreciate it if someone can point what i am missing. TIA #region Excel Check 5: First sheet or multiple sheets selected if(OptionsData.XLCheckSelectedSheet)----(bool) { if(XLwb.Sheets.Count 1 && XLwb.ActiveSheet != XLwb.Sheets.get_Item(1)) { ErrorCounter++; ProcessError(ErrorCounter, "The first sheet is not the selected sheet"); } |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if the first sheet is the selected sheet
thanks sonu,I cant do that because this a tool that is testing a
template to test certain test criteria... if i activate the first sheet then i will be doing it programatcally and that is not the intention... sonu wrote: why dont you activate the first sheet after opening the file. This will solve the problem of error because you then dont need to have this code in your workbook. melody wrote: Hello everyone, I have a program that opens an excel template and then checks to see if the first sheet is selected, if it is then no error but i get an error irrespective of the fact whether the first is selected or not...i am pasting the code here and would appreciate it if someone can point what i am missing. TIA #region Excel Check 5: First sheet or multiple sheets selected if(OptionsData.XLCheckSelectedSheet)----(bool) { if(XLwb.Sheets.Count 1 && XLwb.ActiveSheet != XLwb.Sheets.get_Item(1)) { ErrorCounter++; ProcessError(ErrorCounter, "The first sheet is not the selected sheet"); } |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if the first sheet is the selected sheet
Check if the activesheet index is 1.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "melody" wrote in message ups.com... thanks sonu,I cant do that because this a tool that is testing a template to test certain test criteria... if i activate the first sheet then i will be doing it programatcally and that is not the intention... sonu wrote: why dont you activate the first sheet after opening the file. This will solve the problem of error because you then dont need to have this code in your workbook. melody wrote: Hello everyone, I have a program that opens an excel template and then checks to see if the first sheet is selected, if it is then no error but i get an error irrespective of the fact whether the first is selected or not...i am pasting the code here and would appreciate it if someone can point what i am missing. TIA #region Excel Check 5: First sheet or multiple sheets selected if(OptionsData.XLCheckSelectedSheet)----(bool) { if(XLwb.Sheets.Count 1 && XLwb.ActiveSheet != XLwb.Sheets.get_Item(1)) { ErrorCounter++; ProcessError(ErrorCounter, "The first sheet is not the selected sheet"); } |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet selected, automatic return to top of sheet | Excel Worksheet Functions | |||
copying only selected data from Sheet 1 to Sheet 2 | Excel Worksheet Functions | |||
Check Activesheet for chart sheet or work sheet | Charts and Charting in Excel | |||
how to use sumif function to check date in 1 sheet is < 2 sheet | Excel Worksheet Functions | |||
Updating excel sheet with selected data from another sheet in the same file | Excel Worksheet Functions |