properties

  1. S

    Temporarily unlock VBAProject password to run code

    Hi Experts, I have a number of workbooks (20+) that are being used by multiple users, and the code is password protected in order to hide sensitive information. Currently, I'm working on implementing a UserForm, that will be the same for all workbooks. The form is be imported on open, and that...
  2. K

    changing properties of command button

    many sources mention that when i add a control button from form controls into worksheet and right click on it, there should be option for properties from which i could change font, color , name etc.. but unfortunately when i do right click only options i see are: cut, copy, edit text, grouping...
  3. L

    Remove file ownership properties when saving

    Hi I work at a company with a "Shared" drive, however, any files saved on to this drive by a user are owned by that user and it means nobody else (with their own respective logins) can then open the file in NON Read-Only mode. It always opens the file in Read Only. Is there any way within VBA...
  4. ACommandLineKindaGuy

    Excel Ribbon: Change a control's default screentip/supertip

    Some built-in controls (eg, idMso="FileSaveAs") allows customization of the screentip and supertip properties. Others, such as idMso="CellFillColorPicker" apparently do not. Is there a way to override these properties? TIA John
  5. Z

    VBA rotate picture then then set the properties after the rotation

    im trying to get a picture uploaded then rotated then set properties. this gets my pic uploaded to the properties i want, but not rotated <code class="_34q3PgLsx9zIU5BiSOjFoM" style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-stretch: inherit...
  6. T

    how do i resetthe vba scroll bar to the top position?

    Hi everyone, I'd like a macro that resets the vba scroll bar to the top, I mean the actual bar in the scroll bar, I can do it manually within the properties under value but can't get the vba to set it. can this be done? Thanks Tony
  7. B

    having a problem with the date formula

    In col A I have the date and time together. For example: 1/05/2019 8:09:22 PM In col B I wanted just the date, so I wrote a formula: =LEFT(A2,10) I'm not getting "1/05/2019" the way I'd expect. Instead I'm getting 43470.8398 When I go to Short Date or Long Date I'm seeing the same result...
  8. H

    Insert New Checkbox into next empty cell

    Hi, I am looking to insert a new checkbox into the next empty cell. I can get this far, but then can't specify the properties of the box. See below: ActiveSheet.OLEObjects.Add "Forms.CheckBox.1", Left:=1206, Top:=(Range("T" & Rows.Count).End(xlUp).Offset(1).Top) + 2.25, Width:=12, Height:=12...
  9. C

    VBA workbook.open ReadOnly:=True failing - what's wrong?

    I'm using this code to open a workbook so I can grab some of the builtin properties. Function OpenHidden(ByRef szFullName As String) As Workbook <other code="" here="">... other code here ... Set OpenHidden = Workbooks.Open(szFullName, UpdateLinks:=False, _ ReadOnly:=True...
  10. M

    List properties of images in workbook

    Hi, Does anyone have some code that can loop through each sheet in the activeworkbook and list all shapes/images and their dimensions / properties? I am most interested in the resolution of the images, but it would be useful to know other info too. Can anyone help? thanks, Mark
  11. T

    File Properties

    Does anyone know if it is possible to prevent users from clicking on File -> Properties-> Advanced Properties? I have written code to hide named ranges, so don't want them "revealed" via the above method. Thanks
  12. G

    How to change the width of Ribbon Bar sections - specifically for changing the width of the Table Name field?

    When an Excel Table is selected, the Table Tools tab appears on the Ribbon Bar. The first section of this ribbon is Properties and includes a field called "Table Name:" (This is "Change Table Name" in the "Customize the Ribbon" Excel Option). ... as in the top left corner of this screenshot...
  13. G

    Linked Advanced Properties Not Updating on Info Screen

    I am looking to populate excel file metadata in SharePoint 365 from specific cells within the excel file. I am able to create the linked Advanced Properties within the file, import it into SharePoint, and auto populate the values on the initial load. The problem is, when users update the...
  14. S

    Create a ToggleButton

    I believe I would like to create a ToggleButton. With my limited development background, I believe I want to layer an invisible togglebutton over a cell, so that the user, when they click on the cell will change the visual properties between three states: TRUE - green background with...
  15. L

    Selection.Address in vba

    Hi Why Selection.Address is acceptable syntax. I checked using object browser, that Application.Selection is a property of type "Object". I tried to search for Object, could not find any entery in object browser. My question, What is Selection and how can I find what its functions and...
  16. J

    Data Properties Tab Grayed Out on unprotected and non-shared workbook

    My main issue is that cells are not being refreshed after a macro is run (updating source data). A REF error is generated when Cells are being refreshed post-macro. One of the resolution leads is a correction via Data Properties and the External Data Ranges. Though the Properties tab is...
  17. R

    ListFillRange not staying in properties, but why?

    I have a table (called myDB) that I want to use as the source of content for an ActiveX listbox. I enter that name into the properties of the ListBox and as soon as I hit enter, "myDB" disappears from the ListFillRange field in the properties window. I've successfully done this many times...
  18. R

    Aggregate and Concatenate

    Hello, I have a dataset of property owners, some of whom own multiple properties. Whenever I add them to my database, I need to group up all of the property each owner has into one cell next to their name. Otherwise, I'll have 4 contacts with the same name just different properties. I have...
  19. S

    Fine Tuning a Chart in VBA

    I am working on putting together some charts in VBA and could use some assistance with defining properties in the chart. With ch .HasTitle = True .ChartTitle.Text = aa & StartDate & " to " & EndDate .ChartType = xlLine .SetSourceData Source:=Range(RngStart & ":" &...
  20. T

    New sheet button causes crash

    I have a 200 sheet .xlsm worbook with a lot of code. When I add a new ActiveX command button to a sheet, then click on "Properties" for the button, Excel crashes every time. If I open a completely new workbook, the same thing happens but only once. If I then access the Properties for the for...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top