Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Edit add-in
I saved a file that has code, but the code references a few cells on a
worksheet within the file. I need to edit some info on the worksheet. HOw can I open the xla file and view the worksheets. I can see the code, just not the worksheets. Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Edit add-in
Steph
In the VBA window click on the ThisWorkbook icon in the project explorer find the IsAddin property in the property window, set to False, your worksheets should now be visible back in the Excel window cheers Simon "Steph" wrote in message ... I saved a file that has code, but the code references a few cells on a worksheet within the file. I need to edit some info on the worksheet. HOw can I open the xla file and view the worksheets. I can see the code, just not the worksheets. Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Edit add-in
Also, remember to perform a SaveAs *.xla.
-- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) "Simon Murphy" wrote in message ... Steph In the VBA window click on the ThisWorkbook icon in the project explorer find the IsAddin property in the property window, set to False, your worksheets should now be visible back in the Excel window cheers Simon "Steph" wrote in message ... I saved a file that has code, but the code references a few cells on a worksheet within the file. I need to edit some info on the worksheet. HOw can I open the xla file and view the worksheets. I can see the code, just not the worksheets. Thanks! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Edit add-in
Thanks Gents. Much appreciated!
"Simon Murphy" wrote in message ... Steph In the VBA window click on the ThisWorkbook icon in the project explorer find the IsAddin property in the property window, set to False, your worksheets should now be visible back in the Excel window cheers Simon "Steph" wrote in message ... I saved a file that has code, but the code references a few cells on a worksheet within the file. I need to edit some info on the worksheet. HOw can I open the xla file and view the worksheets. I can see the code, just not the worksheets. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I edit a name in the name box | Excel Discussion (Misc queries) | |||
VBA edit | Excel Discussion (Misc queries) | |||
F2 Edit Key | Excel Worksheet Functions | |||
Why can't I edit my excel document? Edit buttons shaded. | New Users to Excel | |||
Ref Edit | Excel Programming |