Hello,
In Excel Using VB Unprotect 5 tabs, Copy and Move them to new File and Reprotect those Tabs from the previous file.. Thanks in advance...
Best Regads,
AY
I have two workbooks that need to be passed to my other sub. How can I do it?
Thanks!
Something like:
Sub mysub
.
.
.
Call GetSub (Curworkbook, desworkBook)
End Sub
Sub GetSub(Curw...
I have seen this question answered in for VB (stand alone), but I am trying to write a routine in excel and although the I can follow the same instructions as in the first article, the values ...
I just installed the ''Analysis Toolpack" add-in (located in Excel Options --> Add-Ins).
Once I finished installing, the "Analysis Toolpack" is now listed under 'Active Applicaion Add-Ins' (...
Hi Experts,
My doubt is detailed in the attached file.
Thanks,
David.
hot to order sheet column B,C,DG and I...
my code to rdering only 3 column...B,C,D
Option Explicit
Sub Macro1()
Selection.Sort Key1:=Range("B3"), Order1:=xlAscending, Key2:=Range("C3")...
When i am trying to open a Excel 2007 file, i am getting the below error message.
"Excel recovered your formulas and cell values, but some data may have been lost."
When i am opening it, i...
Hi guys, this is what I have.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target.Borders.ColorIndex = 5
End Sub
The problem that I run into is the cell box is changing...
This is going to sound weird, but I want to create a formual in cell T41 that controls cells Q41 and R41. Basically, if Q41 has a number in it, I want R41 to be empty. If R41 has a number in...
I need to move a folder on my file server.
This folder contains about 1500 excel spreadsheets that all contain links to other spreadsheets in the folder.
Basically the link will change f...
Hi,
Two easy questions for updating Graph using Excel VBA Macro.
First I need to update the Graph 'Min' value and Axis value using Macro and used the included code.
I tried replacing ...
I have this code to color cells when double clicking, but it does it only when the cell is blank (no color). How can I modify this code to make it color the cell red when double clicking a cel...
when i import data from access there is a 'tick mark' at the beginning of each cell
example: 'joe brown or 's8a12344
i need to remove the tick mark
it is not seen unless the cell is ...
Is there a way to make changes to the Page Setup, margins, etc., and "globally" apply that page setup to all worksheets in a workbook, instead of having to change them all individually?
After upgrading from 2003, I receive "Cannot run the macro 'macroname'. The macro may not be available in this workbook or all macros may be disabled." I am trying to run macros stored in a ...
Hi all,
Basically, the listed items in UNIX platform are imported to Excel sheet. We can do searching by using the "Auto filter" function; however when the items are imported to Excel, a blan...
Hi all -
I receive a lot of data in Excel format with Products, and one column contains crude abbreviations (like "AUT" for Automobile or "TRA" for Transportation.
I also have the cross-re...
All,
I need a VBA example to open a text file in order to copy its containt to the end of another text file.
Would you mind to provide me with an easy example so I can easily adjust by mys...
When I enter a text in a cell and choose wrap Text, the row height automatically adjusts to fit the cell content. However if the cell is merged with another cell in the same row and I choose ...
One more question in a series. I am using a change event to update an OLAP pivot table based on a cell reference. I have been successful in getting the code to work when I hard code the Memb...
I have a file, that in cell A1 has a merge-to-one-cell value. The format requirements have changed and I now need to un merge this data and have each data point in its own cell.
Experts:
I'm under a strict deadline to create a Spreadsheet...whereby users INPUT data into cells....
ie.
CUSTOMER NAME
ADDRESS
CITY
ST
ZIP
DEBT AMOUNT
Then I have a separate s...
I am having trouble getting the Workbook_Open() sub to call another sub in an Add-In I created. The Add-In is loaded and checked.
I am getting the error "Sub or Function not defined".
Th...
I have office 2007 installed on a machine. If I double-click an excel spreadsheet it opens Excel but doesn't open the file. But if I leave Excel open and open another file it opens just fine...
Hi Excel Guru,
I have a worksheet that I wanted to protect:
For instance my work area is from A1 to K23. Only cell G3 to G20 is accessible and editable.
The users cannot put their cur...
