Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Delete Sheet in Shared WB (Excel 2003)

    Morning all,

    I have a shared report back workbook saved on a shared network which is used by about 10 people. The WB contains macros to create a weekly report from a source list that is maintained in the file.

    One of the macros creates a temporary worksheet which is then deleted once the procedure completes. The problem is that I created the macros while the WB was NOT shared, but when I shared it on the network for all to use, the macro fails to delete the sheet as a shared WB does not allow for this. How can I overcome this? Based on how I designed the macros, I need to insert a temp sheet which must then be deleted. Any advice from anyone???

    Tx
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Delete Sheet in Shared WB (Excel 2003)

    The advice is simple: don't share the workbook. It is a recipe for workbook corruption.

    If you really must use a shared workbook, you could create a temporary workbook instead of a worksheet, and close it without saving when you're done with it.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Delete Sheet in Shared WB (Excel 2003)

    Tx!

    I still find it strange that this feature is available in Excel when so many say it is a source for corruption! <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Regards,
    Rudi

  4. #4
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Delete Sheet in Shared WB (Excel 2003)

    >I still find it strange that this feature is available.....when so many say it is a source for corruption!

    Have you never heard of Master Document in Word? <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15> In that case, the question is not whether the document(s) will corrupt, but when.,....

    As Hans has said, you really need to find another solution in case loss of data becomes a client issue.

    In each recent iteration of Office, M$ has trumpeted "new, improved" sharing methodologies. Perhaps that is their way of saying that the old sharing methods don't work quite as advertised? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Gre

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •