Forum

Miguel Santos
@rhysand
Trusted Member
Joined: Feb 20, 2020
Topics: 0 / Replies: 80
Reply
RE: Macro written in 32 bit System - Not working in 64 bit System[ Win 10 and Office 2019 Prof]

Good afternoon everyone, the links that I have indicated are informative sites, where you can find (constants; Declaring API Functions;...) to write ...

4 years ago
Forum
Reply
RE: Macro written in 32 bit System - Not working in 64 bit System[ Win 10 and Office 2019 Prof]

Hello, in the following two links, you can view and obtain "Api" & "Declarations" and see if this link can help you Migue...

4 years ago
Forum
Reply
RE: VBA/Macro to insert rows based on drop downlist selection

Good morning everyone, I apologize for the delay on this topic, without much time available I didn't understand everything you wanted, but here is...

4 years ago
Forum
Reply
RE: VBA; Creating a folder in Sharepoint.

Good afternoon, I don't know the answer, because I never used Sharepoint but try to see if this can help you in any way Miguel,

4 years ago
Forum
Reply
RE: Inserting 2 rows if a cell meets certain criteria

Hello, sorry for the late reply here are several ways to get what you want, I will leave a simple example (solution 1) Option Explicit ...

4 years ago
Forum
Reply
RE: Inserting 2 rows if a cell meets certain criteria

Hello, Without changing your code, I just made a change (highlighted in red) this is what you want? Sub GSRowsAdd() Dim r As Range Dim I A...

4 years ago
Forum
Reply
RE: VBA disable Copy Cut and paste for important data

Hello, I attached two excel files with the codes to work perfectly, both when opening WorkBooks and when they are closed Regards, Miguel

4 years ago
Forum
Reply
RE: VBA disable Copy Cut and paste for important data

Hello, his method as described, when the workbook with the code is opened, it cancels throughout the application, affecting all other workbooks, so...

4 years ago
Forum
Reply
RE: VBA disable Copy Cut and paste for important data

Hello, Do you want to disable it for the sheet or for a control (example: textbox) in the userform? Example for a textbox in a userform: Priv...

4 years ago
Forum
Reply
RE: Change Order For Chart Series Collection VBA Code

Hello, If you could load a workbook with a sample, it would be much easier, but I will try to help a lot of data is missing about how data is or...

5 years ago
Forum
Reply
RE: Send just page one of active sheet by email

You're welcome, Just do as Purfleet mentioned in his post, because it is the most correct at the moment, I just demonstrated another alternative to...

5 years ago
Forum
Reply
RE: Send just page one of active sheet by email

Hello, in your code, change this part, I highlighted in blue what to add in the code ... With Wb2 If Val(Application.Version) < 12 Th...

5 years ago
Forum
Reply
RE: Send just page one of active sheet by email

Hello, Yes and for that you need to change the CommandButton of the sheet, instead of inserting an Active X control (CommandButton), a control (Com...

5 years ago
Forum
Reply
RE: Send just page one of active sheet by email

Hello, the Purfleet method is correct, but if you don't want to remove the command button, you can simply make it invisible at the beginning of the...

5 years ago
Forum
Reply
RE: Stopping a VBA internal Timer in command button

Hello, To avoid this type of conflict, I mentioned that it was preferable that time be written in a macro instead of in a range, and the macro to s...

5 years ago
Forum
Page 4 / 6