i'm trying to adapt a code i found in an old thread : Don't allow another workbook to open in this instance?
I want to secure an instance for only one workbook, so i adapted the code to fullfit my need.
when i open the workbook wich i want private instance, i see 2 situations
Hi, I would like to disable the option to delete, move, copy or rename one specific worksheet in a workbook, regardless of the activated worksheet in the workbook. I cannot protect the workbook structure, because I want to still be able to delete other worksheets in this workbook without the use...
In Module of my Workbook (coded.xlsm) and for the Worksheet (tab named “ZZZ”) I am using User Defined Function to get outputs in some cells where UDFs are there.
1 line of the code is
If Sheets("ZZZ").Range("WA10").Value = "=1" Then
Should I replace the above lines with...
I am trying to solve the problem with coloring the shapes based on time and I am struggling with it for some time so hope someone can help me with this.
I have 19 shapes on excel sheet and each is having the name Bankomat_ and then number from 1 to 19. The output should be that...
I have searched online for this issue but couldn't find a proper solution.
I have a userform that open (while the workbook itself remains hidden) using the following code:
ThisWorkbook.Windows(1).Visible = False
If Workbooks.Count = 1 Then
Application.Visible = False...
First, any help is greatly appreciated. I'm trying to solve a problem for a co-worker. I am also new to VBA and scripts.
We use excel for inventory and a Dymo Labelwriter 450 Turbo. My co-worker's labeling process is typing in one item number into the Dymo app and then printing it before...
I am currently managing a stock (inventory management) portfolio in Excel. In this, I have my current inventory quantity in column I and two columns in column J & K which I can use to subtract & add amounts from my quantity, so:
Column I = Current quantity
Column J = Enter any...
I currently have the following:
I = quantity
J = subtract any number entered from the quantity after which the number entered will be subtracted in column I and disappear in column J so you can enter a new one in the future
J = add any number entered from the...
Found this post, ScreenUpdating = False not working, that is having a similar issue to mine. From what I've read this is a common issue with Excel after an update Microsoft did.
Below is my code and I cannot figure out how to keep ScreenUpdating set to false. It's not a major issue but the...
I have here a problem wherein I want to find the location of a certain data with no match outside Excel.
Below are reference photo and explanation for clearer description of the problem.
Here are the locations of the data that I will be putting in Excel.
This is a sample of what's...
I am hoping someone can help.
It seems like such an easy thing to do and I just can't find the answer anywhere.
So, I would like to search a range of cells F2:F6 (APPLICATION) for the word "Yes"
The word will be returned in multiple cells and I would like to copy the B2:B6 corresponding cell...
I want to open an application with any code in attached and want to send these number one by one through that application!
That application is bushbullet, which linked with my mobile msg box! https://www.pushbullet.com/ for more understanding!
When I hit button in sheet that call...
Signal is generated in Excel Either Buy or Sell. The Vba should Open the Another Application Perform Functions Like enter amount, name,.....From Excel Only then Submit and Close. Wait for next Signal and Repeat the same Process Again.:)
I'm a newbie about automating external application via sendkeys method.
Now, I can get in the external application, I can write (for example "5"), but I cannot shift the focus two fields on the right (as I manually do without problem). I mean: nothing happens.
Hope you are doing well!!
I need to create an excel sheet for store support.
I have a material which has a QR code and some Location racks with QR Code.
Whenever i get the material to my store i will scan QR code in material and rack.this two data should be recorded in...
So I created and administer an MS Access DB -- approximately 20 end users -- they each have an .accde FE on their desktops, while the back end sits on a network drive.
The primary data entry form has approximately 70+ fields, with currently 50k plus records. There is a subform on this form as...
I'm so glad to be part of this forum and to learn and share excel best practices.
I'm a novice in VBA and need some help on the following. I created a check-list with a multirow highlight feature through VBA that I got inspired from an amazing guy.
However I can't copy and paste...
I have a UDF that does some iterative calculations. It can take anywhere from about 2 to 8-10 seconds to complete its work. The data, which I enter into an InputBox, comes from another application. If I hot-key over to the other application, the UDF stops running until I hot-key back.
Hi everyone I would like to ask a help regarding on Automation Error Exception Occurred. I have created an Excel application. Excep as a front end and Ms Access as a backend. Basically all the data that will input in the Excel userform will be exported to Ms Access. The application is running...
How can i replace the bold part?
Dim a As Long
If ActiveSheet.Name = "Sheet1" Then
a = Application.Caller.Row + 1
Do While Cells(a, 1).Value <> "Yes"
If Cells(a, 2) = "Yes" Then Exit Do
test1234 = test1234 + Val(Cells(a, 2).Value)...