All Questions
29
questions
0
votes
1
answer
790
views
Any way to allow multiple people to edit a coauthored, password protected workbook, at the same time?
I am currently working on a sheet that I want select people to have full access to, while everyone else without the password for the sheet cannot. I can do mediocre and overly complicated solutions ...
0
votes
1
answer
111
views
Evaluate returning #VALUE? when trying to calculate large VSTACK
I am working on a project that is pulling a bunch of spilled data across a ton of sheets that are all in the same spot as the sheets are based off of a template.
Using the name manager I was able to ...
5
votes
1
answer
579
views
Making it so users that do not have macros enabled cannot see other sheets
I am working on a project that wants all users to have macros enabled. It is a shared sheet so I cannot simply hide everything as a baseline and unhide the sheets when Open_Workbook is ran. My goal is ...
0
votes
0
answers
100
views
Any way to disable the Accessibility Checker on a Workbook
I am working on a project that for security reasons needs to have the accessibility checker disabled. Although through settings I can disable it on my excel, I need to find a way either through VBA or ...
0
votes
2
answers
525
views
Making a workbook only able to be opened in the excel desktop app
I am working on a project that requires all of the users on it to be on the desktop app for sheet security reasons. The sheet security can be bypassed by simply not having VBA run by opening the sheet ...
0
votes
1
answer
493
views
Creating a VSTACK'd array from a changing list of spilled references
I am working on a project that requires a large 'pool' of data to pull from and sort from. To keep the workbook efficient, the data is kept in sets of SPILL's, as pulling a raw selected range for the ...
0
votes
1
answer
6k
views
You cannot move or copy a sheet that contains a table
I am trying to copy a sheet to another workbook. It has a slicer that is connected to the table.I want to move both Table and slicer. I get an error saying "You cannot move or copy a sheet that ...
- 1
1
vote
0
answers
62
views
Outlook rule to move a different email than the one that triggered the rule
I get a series of emails (separate, not in the same conversation) for approvals. The first email will have a subject line "ACTION REQUIRED: [XYZ] approval request." If another user ...
- 11
0
votes
0
answers
67
views
How to Insert an autofilter if cell in row range contains value
I'm trying to create a function that inserts a filter within a cell range if a cell contains a value
Here is my code:
Sub FilterFunc()
Dim i As Long, lastCol As Long
Dim rng As Range, cell As ...
0
votes
1
answer
51
views
Strange errors from Excel, when running VBA-macros
The macro stops before execution, points to a Trim(...) call (a VBA built-in function) and says:
Extra tag: 'Can't find project or library'
- 9,469
0
votes
1
answer
2k
views
How can I determine the size of each worksheet in a .xlsb file?
Working on Windwos 10 Enterprise with Excel from Office 365 version 2204, I have a large .xlsb file (>14MB) and want to determine the size of the single worksheets in kB/MB, optimally saving this ...
- 153
1
vote
0
answers
520
views
VBA vs PowerAutomate protecting sheets
I had an excel files with 3 sheets Password protected in order to prevent data insertion in the cells out of the range I needed.
I wrote a VBA script to let the user have a button to add a line to a ...
- 11
0
votes
2
answers
959
views
How to set automatically a reminder depending on meeting time
I don't know how many of you have the same problem, but I work in a company where most of the colleagues wake up considerably earlier than I do.
This led in the past to me missing by 30-40 minutes a ...
0
votes
1
answer
74
views
How to delete a column of one sheet based on value in other sheet by ignoring N/A value?
I am working with an excel file where in Sheet1, I need to compare column C and Column E. If in any row of sheet 1, Column C value> Column E value, then I need to delete certain column in sheet 2.
...
- 5
0
votes
1
answer
56
views
Need to make restriction in the VBA function
I want the below function to pick data from Row till Column H, however this function is picking details up to the last used cell.
Below are the VBA code I'm using, help me to fix this.
Function ...
- 1
0
votes
1
answer
32
views
Dynamic Spill-down Formula Fails to Spill
In an Excel 365 environment, I attempt to insert a dynamic spill-down formula:
Sub WhyDoesThisFail()
Range("A1").Formula = "=SEQUENCE(10)"
End Sub
Strangely I get:
There is a gratuitous @ and ...
- 19.5k
0
votes
1
answer
924
views
VBA Hide Rows that contain N/A
I have an excel file that has dynamic data that changes daily. For example, a user will populate data on the data tab and the percentages are calculated using an "if Command" if there isnt any data N/...
- 87
1
vote
1
answer
2k
views
MacOS Mojave – Microsoft Office 365 2019 – Excel – VBAProject References Missing
I am trying to build up my knowledge of VBA by using sample macros from various sources. One of the difficulties I am facing at the moment is trying to use a macro for taking data from a website.
...
- 13
3
votes
2
answers
10k
views
Is there a way to delete the text within multiple PowerPoint shapes?
I use PowerPoint almost daily as part of my job for reporting. Instead of using text boxes, we like to use Shapes with text inside it to put across ideas e.g. text statements or percentage figures. ...
- 35
1
vote
1
answer
279
views
Force Outlook Filter Refresh
In Outlook 365 I use a filter showing unread and flagged items as my primary view rather than my inbox. This works well except that read items don't disappear from this filter view until I move to ...
- 1,866
0
votes
0
answers
39
views
Copying Data into another sheet when a condition is meet
Does anyone have any idea of a solution or know if what i would like to happen is even possible. I am a complete computer novice and know nothing about ExcelVB, if that's the path to take.
I've a ...
- 1
0
votes
3
answers
451
views
Update macro to expand each row height by X pixels
This works fine to set all rows to 25 pixels.
Sub sbChangeRowHeightMulti()
Rows("3:1000").RowHeight = 25
End Sub
But I want to take the existing row height and add 10 to it.
So something like this ...
- 484
0
votes
1
answer
225
views
Linking formula and standard cells across columns in a table?
I have a workbook W1 which contains a table W1T1. One column (by entering the letter 'x') signals, that this row W1T1Rx has to be copied into another workbook W2.
W2 contains a table W2T1 that has ...
- 101
0
votes
2
answers
6k
views
Excel Macros: Loop through rows
I'm working on another Excel project and, this time, I dipped my feet into VBA macros for the first time. I had very basic knowledge of VB but it's been more than a decade since I used the language so ...
- 353
1
vote
1
answer
329
views
How can I enable my worksheets in Excel to auto-update the filters I have applied to them
I have looked on the other threads to no avail for this. I have a few sheets in my workbook, with one being a data sheet and the others pulling data from it. I have set a filter in these sheets to not ...
15
votes
1
answer
17k
views
How to filter Outlook email using a Rule with a VBA script?
Certain things are not possible using the default e-mail rules like searching subjects or message bodies with wildcards. You can do multiple words but it's not the same if you need the words one ...
- 411
8
votes
5
answers
44k
views
How do I install Visual Basic for Applications 2013 in Office 365?
I've recently taken out a subscription to Office 365 and have downloaded the desktop office programs. However, I'm trying to install an EPM excel addin and it's complaining that it needs "Microsoft ...
- 81
4
votes
1
answer
4k
views
How to modify Out of Office (OOF) settings in Outlook 2010 via VBA
I work for an MSP and we have a single mailbox that we use to process incoming email requests into our ticketing system. I have created a VBA script that runs and processes new emails and such. We are ...
- 51
1
vote
0
answers
10k
views
Missing macros in Word 365
I'm hoping someone can help with this problem. I've just upgraded from preview to Office 365 and the problem is present in both versions (but not in the Office 2010 that I was using before).
Whenever ...
- 11