Working on a spreadsheet containing VBA, last night, closed it and it contained 1 Workbook object (ThisWorkbook) and several Worksheet objects)
Today, in the Project window, two worksheet objects have changed icons and showing as Workbook objects?!
This is causing an issue with a save...
Private Sub Command43_Click()
'Admin Button Bring back nav and other views that are hidden
If Text9.Value = "tam.badal" Then
'UnHide the hidden objects in the navigation pane
Application.SetOption "Show Hidden Objects", True
'UnLock navigation pane...
Within the Visual Basic Editor on the left side there is the Microsoft Excel Objects folder tree that contains all of the sheets in the workbook.
The workbook that I am working in has many sheets and it "pushes down" the Modules folder and Class Modules folder, forcing me to scroll down to see...
I have a worksheet and wish to hide the rows below the last used row. When I select all rows to the last row (52:1048576)and try to hide them, I get the illogical message "Can't push objects off the sheet".
I have searched for objects and there are none on the sheet. I'm using Excel 365. Has...
Excel VBA beginner
I've prepared a userform with a two tab multipage area. I added several labels, textboxes and combo boxes within the first page but had not yet started any code work. I clicked outside the multipage form to edit some other objects and now I am unable to see the multipage tabs...
Good morning! Newbie here, but I've exercised about all the Googling I can do to find the solution and I just have not found one anywhere. Wondering if any expert VBA guys/gals can help a rookie out...
Problem: When manually selecting cells that use List-style Data Validation, I can no...
Is there away to display all headings without using Active Window.
The following code works fine but i don't want to open and activate each sheet just to turn on Headings, as this triggers other objects like WS_Actvate etc.
For Each ws In Sheets
I am curious if there is a way to loop through all control objects in a userform frame or do I have to loop through all objects in the userform and look for that particular frame as a parent? For instance, can I use a for each item in frame type loop?
My Current code draws a mistype error...
I searched throughout this forum, and I'm sure I may have missed a similar post. If it exists, I'd be most appreciative if you'd direct me to where I may find it. :hungry:
So, here's the scenario. (I) Within a userform, I have a multipage with several tabs, all containing a...
I have created one online excel file, and after 2 months when i try to get into the link, shows me a window and tells me that "Too Many Objects, There are to many objects (charts, shapes, pictures etc to display. ........)"
But in this file i don't have, charts shapes etc..
How can i fix it?
Hi dear forum members,
I have the following scenario:
1- Add data validation list to cell A1.
2- Unlock the DV cell (A1) and Protect the worksheet.
3- I have the following code that displays a Msgbox upon double clicking the DV cell (A1):
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As...
Hello at work we are using one program that basicly tells us what kind of variants to use for some specific objects for example :
The macro needs to copy from column : AO(V1) to CP(V54) [AO,AP,AQ,AR,AS....ETC] only the last three numbers and then only the last letter...
I'm trying to avoid a complicated if statement so, I'm trying to find an easy way to compare the property values of two objects. Not the same reference but the values. There's gotta be a way to do that. Thus far, I haven't found anything but Is and IsNot operators.
Hello, I have a small problem. My code is running half of the time. When I press on my command button, my code works fine. When I repress on it to try something else, my code isnt running and I have an error 91. I press on end and retry my command button and it works fine. I dont know what is my...
If possible, I would like to improve my code to be able to copy and paste all data in the sheet, including objects and attachments. Right now it looks like this:
With WBPrepaid.Sheets("Usage Summary")
I am working with the lines:
ArrX = Application.WorksheetFunction.Index(X, 0, 2)
ArrTemp = Application.WorksheetFunction.Index(TempSample, 0, 2)
DistanceMeasure = (1 - Application.WorksheetFunction.Correl(ArrX, ArrTemp)) * 100
I would like to be able to run a simple correlation using...
I would like to be able to loop through arrays to do a test.
I have one big array. It is two dimensional and has 2000 objects. From this array I would like to test every consecutive set of 20 objects to compare to another array. What kind of structure am I looking for here? In other words...
I am working on a UserForm where on click on button embedded objects will be open. I am using below codw for this which is working fine. However i want objects (workbook) should open as read only so no one can edit the same. Pls help
Private Submit_click ()
If cmbox.value =...
Is there a way to copy all picture objects in a specific column over to another column as INDIVIDUAL "Picture (Enhanced Metafile)" pics?
I found this code that selects all objects in a column if it helps...
Dim shp As Shape
Dim r As Range
Set r = Columns("a:c")