objects

I'm using Microsoft 365 for Enterprise, and I'm running into a weird bug trying to apply Custom Views to my workbook. Was wondering if anyone knew what was going on or how to get more debugging information! I've got a fairly large spreadsheet, and one of the sheets has a small amount of data...

I have a worksheet where a map has been created using a number of freeform objects. Each of these objects has been assigned the name of the territory which it represents. I then have a list of each territory, with a reference to the fill colour required. I have this working with the first...

I have a class that imports date values from a worksheet and then stores them in a class along with a lot of other information. The problem is when I try to move from the private variable holding the date information to the public property, it is giving me an overflow error. I tested this two...

Dear All, I have about 200 Worksheets in an Excel Workbook. All the sheets contain various objects. I initially started by selecting the objects by <Find & Select> <Goto Special><Objects> and delete all. I then managed to find a VBA within MrExcel, that was able to delete the objects, but only...

Hi, 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...

Hi 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 ws.Visible =...

Hi, 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...

Greetings everyone! 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 a groupings of several userform objects. With VBA, how can I move that group of objects into a certain position of a userform frame? Some groups have upwards of 20 objects.

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 : https://imgur.com/a/ug8OcaT 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...

Hello, 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") .Activate .Range("A1:Az150").Copy WBExport.Sheets("Usage...