[RESOLVED] Can code be added and developed while a Workbook is shared ?(Excel 2007), or (2003)

[SQLADOman]

Regarding the continued development of a Shared Workbook in Excel 2007, or 2003

The last time I experimented with using a Shared Workbook was about 6 years ago with Excel 2000. I seem to recall having to change it's shared configuration back to a regular workbook in order to make any code change's.

Is that still the case?

[BJHuffine]

I remember it being that way before too but haven't checked 2007. So I just checked it out. No you cannot view or edit code while it is being shared.

This seems to make sense though as when it is shared, the application's assumption is that others may be using the workbook and any associated vba code. So you couldn't allow an edit midstream as it's not maintaining a "production" versus "development" version of your code. Anyways, that probably sounds more like ramble but hopefully makes a little sense.

[Siddharth Rout]

Regarding the continued development of a Shared Workbook in Excel 2007, or 2003

The last time I experimented with using a Shared Workbook was about 6 years ago with Excel 2000. I seem to recall having to change it's shared configuration back to a regular workbook in order to make any code change's.

Is that still the case?

The same is the case now

[SQLADOman]

Thanks BJHuffine -- Yeah I agree with the logic you presented.
I was hoping that during the last 6 years since I last used a shared workbook, that perhaps changes might have been made in that respect.
By my way of thinking, in theory it could be done. For example with some redesigning.and if it is a password protected vb project, when the administrator were to attempt to open the vb editor while anyone else has the file opened, he could gven a message and be blocked from doing so.. And on the flip side, if the administrator has the vb editor open, other users could be blocked from opening the workbook.
-- Oh well, just a pipe dream of mine

Thanks also Koolsid for your confirmation of what I suspected.