Replies

RG,
That worked like a charm. Thak you vry much. It is a little more effort but at least I have a solution going forward. It does kind of make the Start In folder in the standard shortcut set up pretty useless.
Again, thank you very much for your assistance.

Bob G

RG,
None of the permissions have changed. All of the users still have access to this server. It is the main server for our commonly shared files. I have resolved my initial problem by editing the macro that failed that led to my discovery of this chnge in behaviour. Before when the file was opened either with the shortcut or by clicking the file in Windows Explorer, the active foldfer in Excel would change to the folder that the file was started from. Now the only way that the active folder changes is when the file is opened from the file open menu command in Excel. It just bugs me when something works for a long time and then suddenly the behavior changes and no one knows why. In this instance everything worked as normal on Thursday but on the following Tuesday it didn’t.

Bob G.

I am responding to both responses above.
1. some are using XP Excel and others use 2003 Excel
2. everyone is using XP
3. the Start In folder is on a shared server
4. I added the shortcuts at the user’s PC from Windows Explorer

I tried this but it only worked on the whole record set. I could not find anywhere where I could use this at the detail section level of a report.
Thank you very much for your quick respnse.

Bob Gott

Thank you very much. This did exactly what I wanted and I was able to cut the report in half.
Again, thank you very much,

Bob Gott