Groups > microsoft.public.excel.programming > #110757

Enable Outlining / Workbook_Open / Auto_Open

Path	csiph.com!weretis.net!feeder6.news.weretis.net!feeder.usenetexpress.com!feeder-in1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!buffer1.nntp.dca1.giganews.com!nntp.newsgroupbanter.com!news.newsgroupbanter.com.POSTED!not-for-mail
NNTP-Posting-Date	Mon, 15 Oct 2018 08:49:01 -0500
From	ClaireM <ClaireM.160a5048@excelbanter.com>
Newsgroups	microsoft.public.excel.programming
Subject	Enable Outlining / Workbook_Open / Auto_Open
Date	Mon, 15 Oct 2018 14:13:23 +0100
Message-ID	<ClaireM.160a5048@excelbanter.com> (permalink)
Organization	ExcelBanter.com
User-Agent
X-Newsreader
X-Originating-IP
Lines	27
X-Usenet-Provider	http://www.giganews.com
X-Trace	sv3-qLeU3zaubBC0zFaTB0Bf6TAYF8HMkoSJs3Lu4qWxFOekmLL0z8XB8GR87zclN7o5nVgPju7Z1aZK8Tk!swYPbieqxjK54BjCy7BcHHws4C/b7JogSCcMdk8GkgKNXmfFxi0pZqKr76nUtsJGmeu+llSZTjAJ!Vei/z3cQ
X-Complaints-To	abuse@newsgroupbanter.com
X-Abuse-and-DMCA-Info	Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info	Otherwise we will be unable to process your complaint properly
X-Postfilter	1.3.40
X-Original-Lines	9
X-Original-Bytes	2031
Xref	csiph.com microsoft.public.excel.programming:110757

Show key headers only | View raw

I am using a piece of code in ThisWorkbook module to enable outlining on
selected password protected sheets.  I'm confident that the code does
what it's supposed to when it's within a Workbook_Open sub but I am
encountering other difficulties.  If I save the Excel workbook with a
different name, or take a copy of it, when I open the differently titled
file, I get the following error and Excel ultimately crashes:

"Sorry, we couldn't find [original filepath\filename].  Is it possible
it was moved, renamed or deleted?"

If I use Auto_Open instead of Workbook_Open I don't get this error but I
am finding other difficulties with Auto_Open and think that
Workbook_Open should be the right sub to use.

There are no links in the Excel file and also no reference to the
filename in any of the VBA code.  The error/crashing occurs whether the
file is saved on a network drive or a desktop and also occurs on other
users' computers, not just my own. 

I've searched lots of forums and haven't found any reports of the same
issue, any suggestions gratefully received.




-- 
ClaireM

Back to microsoft.public.excel.programming | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Enable Outlining / Workbook_Open / Auto_Open ClaireM <ClaireM.160a5048@excelbanter.com> - 2018-10-15 14:13 +0100
  Re: Enable Outlining / Workbook_Open / Auto_Open GS <gs@v.invalid> - 2018-10-16 04:37 -0400

csiph-web