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!

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!

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!

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!