How to use VBA to set WB to Shared Status

M

MikeZz

Hi All,
I have a macro that builds a new file based on an Accounts Receivable data
file each week.

I'm wondering how I can set the workbook Share settings from within VBA?
Or do I have to manually do it each time I create a new workbook?

Thanks,
MikeZz
 
M

MikeZz

Geeze that was easy.... I thought of looking in Help under save as....
Thought it would be a workbook property set some other way.

Thanks for the help,
MikeZz
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I use VBA to play sound clip from website? 2
How do I write code to "Workbook_Open" from within a VBA? 3
copy WB without VBA: copied sheets link back to source WB 2
Code to delete names works in one WB, but not another WB? 2
The best way to build your own VBA library 2
How can I use vba to populate a website input box? 1
error "Set wb = Workbooks(FilePathName)" 4
Copying From WB To WB 2

Top