Search results

Hi, I have office 365 and when editing my workbook the autosave to one drive sometimes isn't working. Does anyone know why and how to fix please? Thank you

Hello, Can the font and size of the worksheet names from this code be: bookman old style and size 16 bold Thank you Sub ListSheets() Dim ws As Worksheet Dim x As Integer x = 3 Sheets("Menu").Range("A3:A20").Clear For Each ws In Worksheets Sheets("Menu").Cells(x, 1).Select...

Hello, I would like to protect all worksheets but some sheets have different criteria for protection. For instance some allow pivot table and pivot chart, sort, etc. Not all the same. Is there a macro that can handle this? Thank you very much

Hello, On the worksheet 'Stock Manager'. Is there a way to assign each "Go To >>" yellow shapes go to worksheet based on the column C sheet names? For instance cell B5 "Go To >>" link would go to sheet 'Item #1' cell B6. Then cell B6 "Go To >>" link would go to sheet 'Item #2' cell B6...

Hello, I have a list of items in a table that I want sorted but the numbers are not in order. Item #1 Item #10 Should be Item #1 Item #2 Why is this happening? Is there a way to get the order correctly? Thank you

Hello, On the Invoice Template sheet there is a shape "Save" which runs code to save the invoice as PDF and posts the information on the "Invoice Payments" sheet. Is there a way to exit the code if the invoice already exists? Also popup message saying "Invoice has already been saved, nothing...

Hi, On the 'Stock Out' sheet I request macro for columns B, D, F, and H from the 'Invoice Template' sheet. When the code runs it will add rows to the table like I manually entered as an example. Can this be done please? Thank you

Hi, I forgot my password to edit VBA. Can someone please help? Thanks

Hi, I please ask for formulas to fill the schedule with the zone codes like I manually entered. Thank you

Hello, Can VBA fill the Zone codes and colors for the time slots selected? I manually entered the desired results. Thank you

Hello, Can formulas fill the Zone codes and colors for the time slots selected? I manually entered the desired results. Thank you

Hi, What is the VBA code to open workbook to cell E2 on the Calendar sheet and make the cell value the current month number? Thank you

Hi, When I click on the buttons to change the year or month there is an initial delay but after the first click it seems almost instant. Is this a normal expected result? Thanks

Hi, What is the format rule to highlight today on calendar? Thanks

Hi, Does anyone know codes for putting on the buttons in the sheet? Thanks

Hi, Is there VBA that can Open Workbook to certain sheet and change a certain cell value on that sheet to the current month's number? I would like the workbook to open to the sheet called 'Calendar' and the cell E6 to contain the current month's number which would be "6" for this month of June...

Hello, Is it possible to expand the table on the Notes sheet if the table on the Transactions sheet changes? The data on the Notes sheet rows must stay with the Transaction IDs. Please see attached for more information. I need the ability for the Category and Subcategory to be user...

Hello, On the Transactions sheet there are Merchants that I would like apply rules for Category and Subcategory with VBA Code. Criteria is based on the table in columns K to M. The code will paste the Category in column E and Subcategory in column F to the Merchants that each time appear in...