G
Gareth
Hi NG,
I don't like to bandy the word bug around but...
I have an AddIn that connects (ADO) to Access and generates a workbook
on the fly, writing the data into the workbook, storing the primary key
of certain records in cells. The cells' interiors and fonts are colored
such that their contents are not visible to the user plus the cells are
flagged as hidden with the worksheet protected - thus the cells'
contents are not visible to the user.
Periodically the workbook polls Access to check for changes to the
records and updates as necessary. This is managed by setting an OnTime
event.
So far so good. A problem began a couple of days ago (I've been doing a
lot of work since and can't nail down exactly when): if you select a
cell, as expected, you cannot see the contents in the formula bar.
However, if a userform is invoked and subsequently displayed, after a
few seconds (notably when the OnTime procedure is run), the cell's
contents are displayed in the formula bar - as if the sheet was no
longer protected.
The cell's contents remain visible until the form is closed and a
different cell is selected. Reselecting the same cell sees it behave as
normal - until a form is displayed again. It seems to occur for all
cells - all cells on the worksheet are protected and hidden.
There's nothing unusual going on in the OnTime event indeed I have
remmed the code (other than that that sets the next event) out - there's
certainly no unprotecting of the sheet - I reprotected the sheet
manually with a different password from that used elsewhere in the code
to make sure.
I've also taken the following steps
- Cleaned several times with Mr Bovey's code cleaner.
- Exported all modules and manually reimported into a new workbook.
- Installed SP2 (I'm running Office 2003 on XP Home )
I've tried recreating the problem on a different workbook with just a
few lines of code to sustain OnTime procedures but haven't succeeded.
Note the AddIn has four forms, the problem only occurs with two of them,
one has a listbox, one has a listview - the rest are just textboxes,
buttons, checkboxes etc.
Has anyone ever seen this before or does anyone have any suggestions as
to what could be causing this? I'm going to start pulling code out of
the workbook to try and narrow it down but since the worksheet isn't
being unprotected I'm not convinced this will help.
Thanks,
Gareth
I don't like to bandy the word bug around but...
I have an AddIn that connects (ADO) to Access and generates a workbook
on the fly, writing the data into the workbook, storing the primary key
of certain records in cells. The cells' interiors and fonts are colored
such that their contents are not visible to the user plus the cells are
flagged as hidden with the worksheet protected - thus the cells'
contents are not visible to the user.
Periodically the workbook polls Access to check for changes to the
records and updates as necessary. This is managed by setting an OnTime
event.
So far so good. A problem began a couple of days ago (I've been doing a
lot of work since and can't nail down exactly when): if you select a
cell, as expected, you cannot see the contents in the formula bar.
However, if a userform is invoked and subsequently displayed, after a
few seconds (notably when the OnTime procedure is run), the cell's
contents are displayed in the formula bar - as if the sheet was no
longer protected.
The cell's contents remain visible until the form is closed and a
different cell is selected. Reselecting the same cell sees it behave as
normal - until a form is displayed again. It seems to occur for all
cells - all cells on the worksheet are protected and hidden.
There's nothing unusual going on in the OnTime event indeed I have
remmed the code (other than that that sets the next event) out - there's
certainly no unprotecting of the sheet - I reprotected the sheet
manually with a different password from that used elsewhere in the code
to make sure.
I've also taken the following steps
- Cleaned several times with Mr Bovey's code cleaner.
- Exported all modules and manually reimported into a new workbook.
- Installed SP2 (I'm running Office 2003 on XP Home )
I've tried recreating the problem on a different workbook with just a
few lines of code to sustain OnTime procedures but haven't succeeded.
Note the AddIn has four forms, the problem only occurs with two of them,
one has a listbox, one has a listview - the rest are just textboxes,
buttons, checkboxes etc.
Has anyone ever seen this before or does anyone have any suggestions as
to what could be causing this? I'm going to start pulling code out of
the workbook to try and narrow it down but since the worksheet isn't
being unprotected I'm not convinced this will help.
Thanks,
Gareth