HI All

Is it possible to have a bit of code that can unshare a workbook
temporarily upon it opening so that it can be formatted e.g. add text
boxes, have outlining, etc. then have it shared again automatically.

I have a workbook with several sheets, each day I run a macro on the
workbook that adds a sheet , populates it and formats it , but now I
need to share this workbook and can't add these formats once it is
shared.

Help is appreciated thanks