Posts by bamsch

Re: Word List box from external network file

Thanks. I assume FNum is replaced by an integer. Can you confirm?

Thanks again

I want to create a drop down list that is sourced from a linked network file. What I want to do is give people the Word doc and have it link back for its drop down to a Word or Excel file on our shared network. This will allow for me to update the list box without sending them a new Word doc.

Thanks for the help!!!

I have written some VBA that reads a list of business units and puts the Business unit name in some cells and then saves it based on the Business unit name. The problem is that the created spreadsheets still has the code that created them. Therefore, when it is opened, the spreadsheet asks about enabling macros, plus the VBA is viewable.

Ideally what I want to do is delete the VBA before it saves or eliminate the macro enable question. Any ideas?

I have written some VBA that looks in a directory and opens XLS files performs an operation and goes on to the next file. This works fine. It is designed to work through the whole directory. What is not working is when there are links, it stops. I do not want to update links, but want to go forward with my code. How can I do this?

I have what I hope is a simple problem. Let's assume that I have the following cells:

A1 = 15
B1 = =a1*5/3 (displays 25)

What I want to display in c1 is the formula: =a1*5/3

Any ideas?

Re: Advancing to next sheet tab to run code

It gives an error 1004, ungroup method of range class failed.

Beginning of my code:

Cells.select
Selection.EntireRow.Hidden = False
Selection.Rows.Ungroup '<---------------------Error Here

I have written a macro that does some work on a sheet tab. The work book that I need to run this on, for each sheet tab individually, has over 100 tabs. What I want is some code that will let me advance to the next tab automatically and execute my code and so on until it completes the last tab.

Thanks

I want to disable the ability to "Cut" via the tool bar. I already have disabled right clicking and cutting, Ctrl x and drag and drop, but I have not been able to figure out how to disable the Cut icon on the tool bar.

Can anyone help?

Dave, if there are multiple errors will it still work?

Thanks Dave. I think this works great!

Of course, I would leave at least one sheet tab in!

I have been having trouble writing VBA in Excel that allows me to delete worksheet tabs (even if they are hidden). I am getting hung up if the tabs don't exist and therefore I get an error.

Assume there are three sheet tabs (sheet1, sheet2, sheet3) in the workbook. Assume that sheet3 is hidden. Assume we want to delete these tabs and sheet4 (if it was there). Any tabs could be missing or hidden. What I want is a procedure that will delete these 4 sheets if they exist and properly handle any error.

Can anyone please help?

Thanks!

Thanks. When you say a loop, do you mean individually changing each link cell versus any kind of global replace? It is a hard to ID all the cells that are linked to put them in the loop. Any other ideas?

If I am correct, this works only for one link. What I am trying to do is update a number of links (hundreds) in multiple tabs. Any ideas?

Thanks so much! I will check this out and let you know! :thanx:

I am less concerned about how to make the choice than I am trying to get the current link name and then change it to the new selected name. In other words, there will be a single source worksheet and I want to change all the links to a new source.

Thanks!!

I have a large spreadsheet that is designed to be used for reporting of info from other data input spreadsheets that can have many different names although they are formatted exactly the same. What I want to do is allow a user to change the links through out the reporting spreadsheet to point to the particular data spreadsheet that they want to use. I am stuck on how to give them a choice of the particular workbook and then change the links to point to that workbook.