Features Unavailable


create lists
working with XML data (importing, exporting, refreshing, maps, elements, task panes)
Insert or delete cells
delete worksheets
merge or split cells
add or change conditional formatting
add or change data validation
create or change charts or pivotchart reports
insert or change pictures or other objects
insert or change hyperlinks
use drawing tools
protect or unprotect worksheets
group or outline data
create or change scenarios
create or change pivottable reports
change or delete array formulas
use data form
use shared workbooks on web servers


Write, Record or Change macros

The VBA project when a workbook is being shared will be made UNAVAILABLE.
If you find that a VBA project for a workbook is "unavailable" check the shared status of the workbook.
Running the following line of code will close the VBA Editor and place your workbook in a "shared" state.

ActiveWorkbook.SaveAs myfile, xlOpenXMLWorkbookMacroEnabled, , , , , xlShared, , True 

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext