thub.users.profile.tabs.comments.personalized


Thank you. I followed up on the link you provided, but it was my Antivirus program which was the culprit. Merry Christmas.

I also was not able to change the permissions using the Security tab.

If I run a user form and use

 `Application.Visible = false` 

with the VB Editor being closed
with the last form dialog closed
there is no entry in the task manager
for a running Excel instance (maybe
Excel closed, but it was not done
by coding)

I also want to add this to the list of my problems:
If I currently open multiform.xlsm from within excel (default file is Book1.xlsx), then only the Book1.xlsx file is visible, the multiform spreadsheet is not visible - neither code window nor spreadsheets are showing. When I exit the Book1.xlsx a dialog is coming up asking me, whether or not I want to save changes to multiform.xlsm. In the task manager, multform.xlsm are not visible at that point of time.

Today I loaded a second macro enabled workbook which implements a graph according to worksheet data. I was not even able to enter the formula =now() into a cell. Currently there are 18 dialogs integrated in a multipage control. The code is complex for a few forms only and in this case barely exceeds 200 lines. For example: A form showing images, which rely on data written to a worksheet from a SQL statement, having an impact on graphs in that worksheet. The graphs are then exported as jepegs and imported into an image control.

The form in this example shows without flaw, the dialogs don't flicker, the combo boxes and list boxes events seem to execute as to expectation, so I don't think: Endless loop,

The following are my problems
- As I open the workbook, without even touching the Developer Menu, there is a busy cursor showing
- I cannot open the main form (containing the multipage control) in design mode after having executed the macro; I only can access the form in design mode, after
restarting the workbook
- When opening a second workbook, I cannot input a formula

Please, if anybody has an idea about this or find my reasoning faulty, please don't hold back.

Thank you for your help.

This is what I see in my task manager. When the mouse cursor hovers over the project explorer, it shows busy.
153395-tm.png



tm.png (13.4 KiB)

Okay, I'll try commenting out. Thank you.

In the attached image you can see my workspace, when opening the multiform at the location, where most of my "ghost controls" are located. Here is my form and as you can see, not all the controls are listed. The controls surrounded by frames are not identified.

[1]: /answers/storage/attachments/151177-frmreportingcontrols.png

What I did then is: I extended my frames and found all the ghost controls - a sort of replicating my whole form with
default naming convention - and deleted them. Thanks to you I started looking, again.

Yes, you are right.

The problem is that in the same function I used different syntax
for the identical variable. I don't seem to be able to treat one and
the same item as object and as array in the same code segment
(function or sub)

So what I did was to identify the object using the typename function
create appropriate functions and and pass the object to the function

This worked for me.

Thank you.

Maybe this is a bit absurd, but I would like to know how I could manipulate a workbook in a way that above problems would surface. Any suggestions would be welcome.