Macro To Remove Picture Border Or Set It To None

Aug 13, 2012

I have a picture that has been inserted into a worksheet via a macro and I have a number of macros to increase and decrease size. They work fine.

However, whenever I run one of those macros by selecting a button on the worksheet, it results in a border around the picture.

Facts:
- worksheet is called "Admin"
- picture is called "ClientLogo"
- Line.Weight set to "0" or "False" or "xlNone" or removed all result in a border

Question: Code / syntax for removing or setting the border to nothing?

VB:

Sub ReduceShape()
Dim shp As ShapeRange
On Error Goto NoSelectionMade
Sheets("Admin").Shapes("ClientLogo").Select
Set shp = Selection.ShapeRange

[Code]...

View 2 Replies


ADVERTISEMENT

VBA To Add / Remove Border Around Merged Cells

Oct 5, 2012

I've got some VBA that adds and removes a border around a merged cell. I created it by recording a macro and it's pretty clunky. It needs to do this for 6 different merged cells, based on different events and takes around 5 seconds to complete. Not a major problem, but I was hoping that I could make it more efficient. Anyway, code below:

Adding the border:

Code:
Sub AddRAGBorderChart1()
'
' AddRAGBorderChart1 Macro
'
'
Range("D4:M15").Select

[code]....

Removing the border:

Code:
Sub RemoveRAGBorderChart1()
'
' RemoveRAGBorderChart1 Macro
'
'
Range("D4:M15").Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone

[code]....

View 6 Replies View Related

Remove A User Form Border

Jul 28, 2006

The border around a user form is really annoying. Is there any way to remove this so that when you load the user form without a title bar your image you use is just your image and not with a border around it???

View 4 Replies View Related

Remove The Copy/Paste Flashing Border

Sep 4, 2009

After using Copy/Pastespecial in my macro, when it completes I have the flashing border around the range that was copied, (like you do when you do it manually).
What line of code do I need in my macro to make this go away?

View 3 Replies View Related

Spin Button Black Border - How To Remove

Dec 11, 2009

Im creating a form with a spin box option - however when i run it in test I always get a black border around the arrows. Its anoying because I want to make the spinbox small and it overtakes the arrows. I looked everywhere in the properties but can't find where to turn it off. I saw the arrorw and background color but nothing about the border.

I attached 2 pictures for reference.

View 9 Replies View Related

Remove Picture From Image Control

Jan 5, 2007

I know how to load a picture onto an image control using VBA code, but how do I clear the picture? (NOTE: I am not talking about using the properties window in the VBE, I am talking about coding in VB)

View 3 Replies View Related

Delete/Remove Picture From Image Control

May 15, 2008

I want to delete a picture from an image control in a worksheet when pressing a button. So my code is:

Private Sub CommandButton1_Click()
Sheets("Sheet1").Image1.Picture = LoadPicture("")
End Sub

Well, the problem is that this code only works when I create it. If I save and close the excel file when I open it again and I press the CommandButton1 I get the following error: Run-time error '-2147417848(80010108)' Method "Picture of object "IImage" failed.

View 6 Replies View Related

Macro To Draw The Cell Border

Sep 30, 2009

Since I did not know how to do this I used the record macro cheating option.

Excel spit out this chunck of

View 6 Replies View Related

Macro To Set Border Line Styles

Jan 26, 2007

I have a range of data (not a named range, just a selection) and I typically want:

- the top 2 rows to have a heavy border on the left, top and right sides with a light line on the bottom.

- On the bottom line, I need a heavy line on the left, bottom and right sides.

- The body in between needs to have heavy lines on the left and right sides with dots for all in between.

The top 2 lines show titles, the bottom line is for totals and the body in between shows the data.

I've made 3 separate macros that do each part but I'm hoping that they can be integrated into one.

View 9 Replies View Related

Background Color And Border Around Macro

Aug 6, 2008

I am trying to develop an Excel spread- sheet by using some macros. In detail, in my first worksheet, I have something like -

Exp1 ....
Exp2 ....
Exp3 ....
:
:
:
Expn ....

This rows are coming from another worksheet and I have used a macro (developed by me) to populate these rows. Even the number of rows to be populated is not fixed.
However, I would like to add one row with text - " Total Expense" after those rows. This row will have some background color - say Tan - and font color - say Green - and also a border around its own - in nature, the border will be thick, Double and with color Rose. I have tried the following code in macro but not working properly -

Sub Include_Fields_n_Format(loc As String)
tot_exp_scell = loc & f_scell
tot_exp_ecell = loc & (f_scell + 1)
Range(tot_exp_scell, tot_exp_ecell). Merge
Range(tot_exp_scell, tot_exp_ecell).WrapText = True

Range(tot_exp_scell, tot_exp_ecell).Interior.Color = RGB(150, 150, 150)
With Range(tot_exp_scell, tot_exp_ecell).Font...................

View 4 Replies View Related

Macro For Conditional Formatting Bottom Border

Jul 9, 2014

Possible to create a macro that would detect end page (jumping from page 1 to page 2 for instance) and add a bottom border at the last row of the page.

I have attached a sample where I highlight in green the end of the page and added manually the bottom border (I did it only for the first end pages).

View 7 Replies View Related

Create A Border Macro When Open The File

Jul 26, 2009

I have recorded a macro which will create the border for me when the file is opened, but it turned out too long. if someone can show me how to reduce the codeing. I have the attached file.

Range A5 to E20 thin Border all sides and thick border allround (16 rows)
Range A21 to E36 thin border all sides and thick border allround (16 rows)

end range is A356.

View 5 Replies View Related

How To Replace Border Style With Macro Across Entire Data

Jul 11, 2014

How can I replace the border style with a macro across my entire data?

I would have assumed something like this would work:

[Code] .......

View 2 Replies View Related

Macro To Draw Border And Set Formatting In Pivot Table

Apr 13, 2012

I came across an issue on the pivot table after refreshing data. I always need to manually redo the border and formatting. I figure that it is because every time when some new group have move to another day, it change the pivot table layout again and so on.

1) I manage to draw border for Day 1, 2, 3, 4 and 5 but 'Beyond Day 5' i dont know how to do it.
2) Sometime some Day X will have no data then i will have problem with my script. (example pivot table doesnt show Day 2)
3) Possible to do looping for that?

I had attached a simple file.

View 6 Replies View Related

Format Chart/Plot Area With Border Macro 2007

May 16, 2008

This seems so simple but i looked everywhere and i cannot find the vba script to add a 3 point solid black line border around the chart and plot area of my graphs. The record macro option does not record this.

View 3 Replies View Related

Excel Macro To Add Button Double Border To Rows Based On Criteria?

Aug 22, 2014

I want to add buttom double border to cells in rows, based on data in column A via VBA,

I have a title in A1 called PO, every PO have variable numbers of rows. so i want buttom double borders for each group of PO.

I added an attachment of "Before and after" example.

View 2 Replies View Related

Excel 2003 :: VBA Macro - How To Prevent Cell Border Changes To Unprotected Cells

Aug 3, 2012

I have unprotected cells in excel where I need to change the content (number) and cell color, but I don't want the cell borders to change. I'm a beginner with vba. I've tried protect sheet and workbook options, but looks like I need a vba code and don't know where to start.

Win 7
Office 2007

View 4 Replies View Related

Excel 2010 :: Paste Picture Into Small Picture / Diagram Box?

Mar 19, 2012

In Excel 2010, is there any way to paste a picture into a small picture/diagram box, and upon double clicking the picture it would explode to a larger size? And I guess double clicking it again would make it return to its original (smaller) size. I would be pasting several pictures into several different picture/diagram boxes and would need this to be a relative reference so that upon selection it explodes the appropriate picture?

View 1 Replies View Related

Put Chosen Picture In Comment & Retrieve Picture On Other Sheet

Nov 18, 2007

I want to have a sample file in excel which store picture of student in comment, I did this, but when I want to insert picture the file dialog appears, and if I click cancel, then there is an error, why? If some one optimise the code it would be very nice

View 6 Replies View Related

Picture Macro ...

Oct 16, 2009

I copied this from another post and am having trouble getting it to work for me. I want to be able to run this macro, find a picture on my computer which could be located anywhere and then have it paste in specific cells.

Whenever I run this it lets me find the picture I want and when I select it I get error message that says "compile error" Syntax Error". It then does not put the picture on the sheet.

I tried to zip and attach the work sheet multiple times but keep getting error message and won't let me attach......"forum excel database has encountered a problem" ....

View 9 Replies View Related

Macro For Pop-up Window With Picture

Jul 19, 2007

A macro, which would allow me to click on a particular cell, which will have an ID number (1 through 34), each ID# is attributed to a particular employee. These ID# are located in my spreadsheet in columns B & G, and the ID #'s begin initially in B6 & G6 and continue downward to B34 & G34. These ID #'s are used in a vlookup type formula which covers 35 pages of this workbook. What I'd like to do is be able to click on any cell between B6& B34 (and/or the same in G6&G34), which has a particular ID # in it and have the photo of that particular employee designated with that ID# pop up in a window generated by the macro. I hope this makes sense! Any help would be greatly appreciated. My 1st sheet in my workbook is my "lookup" tab, which contains my ID# list and numbering sequence affiliated to each employee. So I'm not sure if I'd need to put the photograph of the employee in a column next to the employees name or have a folder designated with all my pictures in a certain directory, etc.

View 11 Replies View Related

How To Open .jpg Picture With Macro

Feb 23, 2009

I use the following macro to open excel files. Can this be modified to open a picture ppppp.jpg?

. . . or, can someone help me with a new macro that can open pictures

. . . I would still like to have the file checking options to see if the picture is already open and if not, that it actually exists.

View 11 Replies View Related

Format A Picture With A Macro

Oct 11, 2009

I'm watching an educational D V D on my computer, and take notes in excel. I repeatedly use the print screen command, then go to excel and paste in the picture, though it is too large. I resize it to 50% and I'm done. What kind of code do I need to use to paste and shrink the picture to 50%? Also, how do I attach a shortcut key to this action (for example Ctrl+M)

View 14 Replies View Related

Macro: Does Picture Exist

Nov 30, 2006

I have been able to piece together something that works great for me till i tested it on a item that I did not have a picture referanced to it.

I am looking for some help with what i guess is an "if" statement that if no picture is found paste "Sorry no picture found" in c3.

Here is code

Sub Copy_Cells()
'Copying the row
addr = ActiveSheet.Shapes(Application.Caller).TopLeftCell.Address
Intersect( Range(addr).EntireRow, Range("b:ak")).Select
Selection.Copy Sheet2.Range("b65536").End(xlUp).Offset(0, 0)
Sheets("sheet3").Select

'Picture code
MyPicturesName = Sheets("sheet3").Range("i5").Text
Sheets("sheet5").Shapes(MyPicturesName).Copy
Sheets("sheet3").Range("c3").Select
ActiveSheet.Paste
Range("a1").Select

'hide tabs
Sheets("Sheet1").Select
ActiveWindow.SelectedSheets.Visible = False

End Sub

View 4 Replies View Related

Display A Picture In A Cell When The Picture Name Is Selected

Jun 18, 2014

I have done the above where when I select a picture name from a drop down list it displays the relevant picture in another cell by using the IF function in the named formula

My question is why cant I use VLOOKUP instead of IF in the named formula. When I use it it comes with an error.

View 6 Replies View Related

Macro To Enter Shape Or Picture?

Sep 30, 2012

I am making a spreadsheet file for our football offcials group to review rules.

I tried to record a macro to copy a shape and put it into the spreadsheet, but the shape does not copy.

How do I get the shape to copy into the spreadsheet?

What I want is for them to "think" what they would do and then click the macro and it will show them where the ball would be after the foul/fouls.

View 2 Replies View Related

Insert Name Of Picture In Excel VBA Macro

Apr 18, 2014

The following macro enables be to insert picture from a given location. My query is I want to insert the picture name once the pictures are inserted in the excel worksheet.

[Code] .....

View 3 Replies View Related

Macro: Variated Background Picture

Feb 27, 2009

My macro generates some graph from some datas. Datas are in some range and when I filtering it shows only filtered values. I use Fixed axis (min and max) because if I use Auto it fit data to the window.

My problem is: I would like to use Auto axis because my layout would be better but bacground picture remains the same and it's useless. Background picture should change as I change filters.

example:

untitled.JPG
here is picture:
current situation is 1.

With Auto axis I get 2. (blue B and green D are filtered results)

And I would like to have 3.

Is it possible that background picture variate as datas variates?

View 11 Replies View Related

Macro To Show A Picture Based On A Certain Cell?

Apr 25, 2014

macro which can show a picture of a certain cell and if I change the value of that cell the picture will be changed to the new cell value,

Like

If I put in cell A1 value DOG, so the pic in cell B1 is a dog pic that I defined before, and if I change that value to a cat, the pic should be changed to another pic.

View 1 Replies View Related

Automatically Refresh Picture Links With A Macro?

Mar 13, 2014

I'm working on a dashboard that shows some market developments. One of the problems is that I'm using linked pictures and a combo box to choose the appropriate graph, but sometimes the picture link returns a blank. Apparently this is a bug that can be fixed by running a macro that refreshes the picture link. Unfortunately I'm a real beginner with this kind of stuff.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved